Do everything in one place
Customize your Google BigQuery and Microsoft Sharepoint integration with the following
triggers and actions.
Triggers
When this happens…
Google BigQuery
- New job completedNew job completed in BigQuery
- New rowNew row in a table in BigQuery
- New rows BatchNew batch of rows in a table in BigQuery
- Scheduled query BatchNew scheduled query using custom SQL in BigQuery
Any other trigger you can think up
Microsoft Sharepoint
- New row in sharepoint listNew row in Sharepoint list
- New/updated file in folder hierarchyNew/updated file in Microsoft Sharepoint folder hierarchy
- New or updated fileNew or updated file in Microsoft Sharepoint folder
- New/updated row in Sharepoint listNew/updated row in Sharepoint list
Any other trigger you can think up
Actions
Do this…
Google BigQuery
- Custom actionCustom action in Google BigQuery (Custom)
- Get batch of rows by Job ID BatchGet batch of rows from query result in BigQuery
- Insert rowInsert a row in table in BigQuery
- Insert rows BatchInsert rows in table in BigQuery
- Load data into BigQueryLoad data into table on BigQuery
- Load data from Google Cloud Storage into BigQueryLoad data from Google Cloud Storage into table on BigQuery
- Run custom SQL in BigQueryRun custom SQL in BigQuery
- Select rows (Old) BatchSelect rows asynchronously in a table in BigQuery
- Select rows BatchSelect rows in a table in BigQuery
- Select rows using custom SQL (Old) BatchSelect rows asynchronously using custom SQL in BigQuery
- Select rows using custom SQL BatchSelect rows using custom SQL in BigQuery
- Select rows using custom SQL and insert into table BatchSelect rows using custom SQL and insert into table in BigQuery
Any other action you can think up
Microsoft Sharepoint
- Custom actionCustom action in Microsoft Sharepoint (Custom)
- Add row in sharepoint listAdd row in Sharepoint list
- Copy fileCopy a file in Sharepoint
- Create folderCreate folder in Sharepoint library
- Create rows BatchCreate rows in Sharepoint list
- Delete file or folder from libraryDelete a file or a folder from Microsoft Sharepoint library
- Delete rowDeletes a row in Sharepoint list
- Download attachmentDownload attachment in Sharepoint list
- Download file from libraryDownload file from Microsoft Sharepoint library
- Get file and folder detailsGet details of a file or folder in Sharepoint
- Get file or folder permissions BatchGet permission details of a file or a folder in Microsoft Sharepoint
- List files and folders within a folder BatchList files and folders within a folder in Microsoft Sharepoint
- Move fileMove a file in Sharepoint
- Rename file or folderRename a file or a folder in Sharepoint
- Search file by name BatchSearch file in Sharepoint library
- Search list items BatchSearch item in Microsoft Sharepoint list
- Search users BatchSearch users in Microsoft Sharepoint library
- Update file using file contentsUpdate file in Microsoft Sharepoint library
- Update file metadataUpdate file metadata in Sharepoint library
- Update rowUpdates a row in Sharepoint list
- Update rows BatchUpdate rows in Sharepoint list
- Upload attachmentUpload attachment in Sharepoint list
- Upload file in libraryUpload file into a folder in Sharepoint library
Any other action you can think up
The wonders of Workato
Easily set up as many intelligent automations you need.
- 1000s of ready-to-use templates
- Accelerate work with intelligent automation
- Do it yourself, faster
- Build bots. Put them to work