Do everything in one place
Customize your Google BigQuery and Replicon 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
Replicon
- New clientNew client created in Replicon
- New or updated invoice ready to syncNew/updated ready to sync invoice in Replicon
- New projectNew project created in Replicon
- New userNew user created in Replicon
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
Replicon
- Custom actionCustom action in Replicon (Custom)
- Assign all users to projectAssign all users to project in Replicon
- Assign co-manager to projectAssign co-manager to project in Replicon
- Add line item to expense sheetAdd line item to expense sheet in Replicon
- Assign manager to projectAssign manager to project in Replicon
- Assign user to projectAssign user to project in Replicon
- Update invoice statusUpdate status for invoice in Replicon
- Create clientCreate client in Replicon
- Create expense sheetCreate expense sheet in Replicon
- Create projectCreate project in Replicon
- Create project taskCreate project task in Replicon
- Create timesheetCreate timesheet in Replicon
- Create userCreate user in Replicon
- Get all tasks for a project BatchGet all project task in Replicon
- Get client detailsGet client details from Replicon
- Get project cost amount detailsGet project cost amount details from Replicon
- Get expensable projects BatchGet expensable projects by expense sheet in Replicon
- Get invoice details by URIGet invoice details from Replicon
- Get invoice item details by URIGet invoice item details from Replicon
- Get project detailsGet project details from Replicon
- Get list of project team members BatchGet list of project team members from project in Replicon
- Get task assignments for resource BatchGet task assignments for resource in Replicon
- Get user detailsGet user details from Replicon
- Get list of clients BatchGet list of clients from Replicon
- Get all eligible project leaders BatchGet all eligible project leaders from Replicon
- Get list of projects BatchGet list of projects from Replicon
- Get list of users BatchGet list of users from Replicon
- Get payroll details BatchGet payroll details for a specific pay period from Replicon
- Search clients BatchSearch clients in Replicon
- Search programs BatchSearch programs in Replicon
- Search projects BatchSearch projects in Replicon
- Search users BatchSearch users in Replicon
- Submit expense sheetSubmit expense sheet in Replicon
- Update clientUpdate client in Replicon
- Update payment due date and issue dateUpdate payment due date and date of issue for invoice in Replicon
- Update invoice descriptionUpdate description for invoice in Replicon
- Update invoice sync statusUpdate sync status for invoice in Replicon
- Update projectUpdate project in Replicon
- Update project clientUpdate project client in Replicon
- Update project end dateUpdate end date for project in Replicon
- Update project fixed bid rateUpdate project fixed bid rate in Replicon
- Update project nameUpdate project name in Replicon
- Update project programUpdate program to project in Replicon
- Update project statusUpdate project status in Replicon
- Update userUpdate user in Replicon
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