Extract Google Slides data with IDP by Workato ​

Click the trigger in the recipe editor.

Click the trigger

Use the Time unit drop-down menu to select Weeks.

• Available options include Minutes, Hours, Days, Weeks, Months, or Custom schedule.

Enter 1 in the Trigger every field to run the recipe weekly.

Choose the days the recipe should run in the Days of the week field. For example, select Monday.

Specify the time for the recipe to run in the Trigger at field. For example, enter 12:00 AM.

Optional. Select the timezone in the Timezone field. The default is America/Los_Angeles if left blank.

Optional. Set the start date and time in the Start after field, or leave it blank to activate the trigger immediately after you start the recipe. You can't change this value after you run or test the recipe.

Configure the trigger

Click Save.

Search for Google Drive and select it as your app.

Select the Search files or folders (Batch) action.

Use the Files or folders drop-down menu to select Files.

Search files or folders (Batch) action

Set Folder to Select folder and use the drop-down menu to select the folder you plan to search for files.

Optional. Enter a name in the Name field to fetch files or folders that contain partial matches.

Go to the Query field and enter the following value to filter your search to Google Slides files:

mimeType='application/vnd.google-apps.presentation'

Click Save.

Map the Google DriveStep 2 datapill to the Input list field.

Set up the Repeat for each step

Use the Repeat mode drop-down menu to select One item at a time.

Use the Clear step output drop-down menu to select No.

Click Save.

Search for Google Drive and select it as your app.

Select the Export file action.

Use the File drop-down menu to select Use file ID.

Set up the Google Drive Export file action

Map the ForeachStep 3 datapill to the File value field.

Set MIME type to Select MIME type and use the value drop-down menu to select PDF.

Click Save.

Search for IDP by Workato and select it as your app.

Select the Process a document using IDP by Workato action.

Map the Google DriveStep 4 datapill to the File contents field.

Set up the Process a document using IDP by Workato action

Set File type to Select from list and use the value drop-down menu to select PDF.

Use the Document type drop-down menu to select Documents.

Use the IDP version drop-down menu to select OCR augmented LLM extraction.

Copy the following JSON schema and paste it into the Fields to identify section:

[
  {
    "name": "FileName",
    "type": "string",
    "optional": false,
    "description": "Project Name",
    "control_type": "text",
    "label": "Project name"
  },
  {
    "name": "ProductManager",
    "type": "string",
    "optional": true,
    "description": "Product Manager",
    "control_type": "text",
    "label": "Product manager"
  },
  {
    "name": "PrintFileDeliveryDate",
    "type": "string",
    "optional": true,
    "description": "Print File Delivery Date",
    "control_type": "text",
    "label": "Print file delivery date"
  },
  {
    "name": "ProductFeatureName",
    "type": "string",
    "optional": false,
    "description": "Presentation feature or topic",
    "control_type": "text",
    "label": "Brand range"
  },
  {
    "name": "FeatureOverview",
    "type": "string",
    "optional": true,
    "control_type": "text",
    "label": "Feature overview",
    "description": "Summary or overview section title"
  },
  {
    "name": "Marketswherelaunched",
    "type": "string",
    "optional": true,
    "description": "Markets Where Launched",
    "control_type": "text",
    "label": "Markets where launched"
  }
]

Click Save.

Search for Google Sheets and select it as your app.

Select the Add row action.

Use the Google Drive drop-down menu to select the drive you plan to use.

Set up the Add row action

Use the Spreadsheet drop-down menu to select the spreadsheet where you plan to add the new row.

Use the Sheet drop-down menu to select the sheet where you plan to add the new row.

Expand the Columns section.

Map the File nameStep 5 datapill to the ProjectName field.

Map the Product managerStep 5 datapill to the ProductManager field.

Map the Print file delivery dateStep 5 datapill to the PrintFileDeliveryDate field.

Map the Product feature nameStep 5 datapill to the ProductFeatureName field.

Map the Feature overviewStep 5 datapill to the FeatureOverview field.

Map the Markets where launchedStep 5 datapill to the Marketswherelaunched field.

Map the datapills to the corresponding fields

Click Save.