Do everything in one place
Customize your Excel and JDBC integration with the following
triggers and actions.
Triggers
When this happens…
JDBC
- New rowNew row in a table in JDBC source
- New rows BatchNew batch of rows in a table in JDBC source
- New rows via custom SQL BatchNew batch of rows via custom SQL in JDBC source
- Scheduled query BatchScheduled query using custom SQL in JDBC source
- New/updated rows via custom SQL BatchNew/updated batch of rows via custom SQL in JDBC source
Any other trigger you can think up
Actions
Do this…
Excel
- Custom actionCustom action in Excel (Custom)
- Add rows in batch BatchAdd rows in batch in Microsoft Excel
- Add a tableAdd a table in Microsoft Excel
- Add a worksheetAdd a worksheet in Microsoft Excel
- Delete a rowDelete a row in Microsoft Excel
- Get cells BatchGet cells from range in Microsoft Excel
- Get rows BatchGet rows from table in Microsoft Excel
- List tables BatchList tables in Microsoft Excel
- List worksheets BatchList worksheets in Microsoft Excel
- Search workbooks BatchSearch workbooks in Microsoft Excel
- Update a rowUpdate row in Microsoft Excel
Any other action you can think up
JDBC
- Export query resultExport query result as a CSV file in JDBC source
- Run custom SQL BatchRun custom SQL in JDBC source
- Run long query using custom SQLRun long query using custom SQL in JDBC source
- Select rows BatchSelect rows in a table in JDBC source
- Select rows using custom SQL BatchSelect rows using custom SQL in JDBC source
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