Skip to main content

Google Sheets

Lets an agent list, create, and edit spreadsheets in a Google Drive account you connect.

What it can do​

  • list_spreadsheets (optional name_contains)
  • create_spreadsheet, add_sheet, list_sheets
  • get_values — read a range
  • update_values — write to a range

spreadsheet_id comes from the URL: docs.google.com/spreadsheets/d/{id}/edit.

How to get credentials​

Google OAuth — no token to copy.

  1. Start the setup in FlyMyAI; enter the Google email you want to use.
  2. On the Google consent screen, sign in with that account.
  3. Approve the requested scopes (spreadsheets, drive.readonly).
  4. You land back in FlyMyAI; the tool flips to Configured.

Fields to fill in FlyMyAI​

FlyMyAI fieldWhere it comes from
USER_GOOGLE_EMAILThe Google account whose Sheets the agent should access

Troubleshooting​

  • 403 on 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 without name_contains.