Do everything in one place
Customize your Google BigQuery and Guru 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
Guru
- Collection Trust Score ChangeTriggers when the selected collection's trust score changes
- New Board Created Real-timeTriggers when a new Board is created
- New Card Archived Real-timeTriggers when a user archives a Card
- New Card Comment Real-timeTriggers when a user comments on a Card
- New Card Copied Real-timeTriggers when a user either copies the content within the Card or clicks on the "Card Copied content" button
- New Card Created Real-timeTriggers when a new Card is published
- New Card Favorited Real-timeTriggers when a user clicks the heart icon to add the card to "My Favorite Card" list
- New Card Link Copied Real-timeTriggers when a user clicks on the "Card Copy link" button
- New Card Unfavorited Real-timeTriggers when a user removes a Card from their "My Favorite Card" list
- New Card UnverifiedTriggers when a Card becomes unverified
- New Card Updated Real-timeTriggers when a user makes an edit to a Card
- New Card Verified Real-timeTriggers when a user verifies a Card
- New Card Viewed Real-timeTriggers when a user views a Card
- New Collection Created Real-timeTriggers when a new Collection is created
- New Group Created Real-timeTriggers when a new Group is published
- New Member Real-timeTriggers when a new member was invited to team
- New Tag Created Real-timeTriggers when a new Tag is created
- New User Added to Group Real-timeTriggers when a User is added to a Group
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
Guru
- Add Tag to CardAdds an existing Tag to a Card.
- Add User to GroupAdds a user to a Group.
- Archive CardArchives a Card.
- Create CardCreate a new Card
- Create GroupCreates a new Group
- Create TagCreate a Tag
- Create Tag CategoryCreate a Tag Category
- Get Board DetailsGet Board details
- Get Card DetailsGet Card details
- Get Collection DetailsGet Collection details
- Get Group DetailsGet Group details
- Get Tag DetailsGet Tag details
- Get Team StatsGet Team stats
- Get User DetailsFind User details
- Invite UserAdds a user to your Team
- List CollectionsList Collections
- List Group MembersList Users within a Group
- List Tag CategoriesList Tag Categories
- Remove User from GroupRemoves a User from a Group
- Remove UserRemoves a User from your Team
- Restore CardRestores a previously Archived Card
- Search for Archived CardSearch for a card that has been archived
- Search CardsSearch Cards
- Search GroupsSearch Groups
- Unverify CardUnverifies a Card
- Update CardUpdate a Card
- Verify CardVerifies a Card
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