Google Sheets
Lets an agent list, create, and edit spreadsheets in a Google Drive account you connect.
What it can do
| Method | What it does |
|---|---|
list_spreadsheets | List Google Sheets in Drive; name_contains optional, page_token for next page. |
create_spreadsheet | Create a new spreadsheet; returns spreadsheet_id and URL. |
add_sheet | Add a new tab to a spreadsheet by spreadsheet_id. |
list_sheets | List tabs in a spreadsheet: sheet_id, title, index, grid size. |
get_values | Read cell values by A1 range. |
update_values | Write values to a range (overwrites the target cells). |
How to get credentials
Google OAuth - no token to copy.
- Start the setup in FlyMyAI; enter the Google email you want to use.
- On the Google consent screen, sign in with that account.
- Approve the requested scopes (
spreadsheets,drive.readonly). - You land back in FlyMyAI; the tool flips to Configured.
Fields to fill in FlyMyAI
| FlyMyAI field | Where it comes from |
|---|---|
USER_GOOGLE_EMAIL | The Google account whose Sheets the agent should access |
Troubleshooting
403on a specific sheet - the account doesn't have edit access. Share the sheet with that account, then retry.- Empty result from
list_spreadsheets- the filter didn't match. Try withoutname_contains.
Links
We love our partners - FlyMy.AI builds with the best. Thanks, Google Sheets!