Google Sheets
Google Sheets
Section titled “Google Sheets”Connect Google Sheets from Integrations in the Workforce AI dashboard, then ask your AI employee to use it as part of a job. The action reference below is normalized from the current Google Sheets toolkit reference into plain business language.
Good first jobs
Section titled “Good first jobs”- Find the records that match a business question.
- Add reviewed information to the right record.
- Prepare a weekly summary from a saved view or table.
Connect Google Sheets
Section titled “Connect Google Sheets”- Open Workforce AI and choose Integrations.
- Find Google Sheets and select Connect.
- Complete the provider sign-in or connection details shown on screen.
- Return to your AI employee and give it one clear job using Google Sheets.
The provider controls which accounts and workspaces you can authorize. You can reconnect or remove the connection from the Integrations page.
Available tools
Section titled “Available tools”- Add sheet
- Aggregate metric changed trigger
- Batch get
- Batch update
- Batch update values by data filter
- Cell range values changed trigger
- Conditional format rule changed trigger
- Create chart
- Create google sheet1
- Create spreadsheet column
- Create spreadsheet row
- Data validation rule changed trigger
- Delete chart
- Delete dimension
- Delete sheet
- Developer metadata changed trigger
- Execute sql
- Filtered range values changed trigger
- Find replace
- Find worksheet by title
- Get batch values
- Get conditional format rules
- Get data validation rules
- Get sheet names
- Get spreadsheet by data filter
- Get spreadsheet info
- Get table schema
- Insert dimension
- List charts
- List tables
- Lookup spreadsheet row
- Move chart
- New rows trigger
- New sheet added trigger
- New spreadsheet created trigger
- Query table
- Search developer metadata
- Search spreadsheets
- Set basic filter
- Set data validation rule
- Spreadsheets sheets copy to
- Spreadsheets values batch get by data filter
- Spreadsheets values update
- Spreadsheet metadata changed trigger
- Spreadsheet properties changed trigger
- Spreadsheet row changed trigger
- Spreadsheet search match trigger
- Table query result changed trigger
- Table schema changed trigger
- Update chart
- Update dimension properties
- Update sheet properties
- Update spreadsheet properties
- Update values batch
- Values get
- Values update
- Worksheet names changed trigger
Workforce AI applies its approval rules to actions that create, change, send, publish, move, or remove information. When an action needs approval, you will see it in Approvals before it runs.
How to ask for the work
Section titled “How to ask for the work”Use the result you want and the record or audience involved:
Using Google Sheets, find the records that match a business question. Show me the result here.
For recurring work, add the timing, the information to use, and the finish line. You can save a successful job as a schedule when it should run on a regular rhythm.
Common questions
Section titled “Common questions”Does Workforce AI need my Google Sheets password?
Section titled “Does Workforce AI need my Google Sheets password?”Use the provider sign-in or connection screen shown by Workforce AI. OAuth providers keep your password with the provider.
Why is a proposed action waiting?
Section titled “Why is a proposed action waiting?”Open Approvals in Workforce AI. Review the complete proposal, then approve or deny it.
How do I switch to another Google Sheets account?
Section titled “How do I switch to another Google Sheets account?”Open Integrations, remove or reconnect Google Sheets, and choose the account you want during the provider sign-in.
Can I use Google Sheets in a scheduled job?
Section titled “Can I use Google Sheets in a scheduled job?”Yes. Once the connection and job work the way you want, tell your AI employee when the job should run.