WA.cr

Connect Google Sheets

Link a Google account so your Auto Flows can add, update and look up rows in your spreadsheets.

Connecting Google Sheets lets your Auto Flows write to your own spreadsheets — saving each new lead as a row, updating a customer's record, or looking up a booking to reply with it.

There are two ways to connect, and the wizard asks you to choose first.

  • Sign in with Google — acts as your Google account, so it can already see the spreadsheets you own. It needs a one-time setup in Google Cloud.
  • Service account — a robot account with its own email address. Nothing expires and there is no sign-in screen, but you share each spreadsheet with it, like a teammate.

Steps

  1. Open Integrations and choose Connect Google Sheets.
  2. Pick how you want to connect.
  3. In the Google Cloud console, create a project or pick one you already use.
  4. Open APIs & Services → Library and switch on both the Google Sheets API and the Google Drive API. Drive is what lets us list your spreadsheets so you can pick one.
  5. Follow the rest of the wizard for the method you chose (below).
  6. Finish, then open an Auto Flow and add a Google Sheets step.

If you're signing in with Google

  1. Open APIs & Services → OAuth consent screen. Add an app name and your support email, choose External, and add your own Google address as a test user.
  2. Open Credentials → Create credentials → OAuth client ID and choose Web application.
  3. Under Authorised redirect URIs, paste the address the wizard shows you — use its Copy button, because it has to match character for character.
  4. Copy the client ID and the client secret into the wizard.
  5. Press Sign in with Google and approve access.

While your app is in Testing, Google cuts access off after seven days and your connection stops working. Once you've confirmed everything works, press Publish app on the consent screen. The "unverified app" warning is expected when only your own business signs in.

If you're using a service account

  1. Open IAM & Admin → Service accounts and create an account.
  2. Open it, then choose Keys → Add key → Create new key → JSON. The file downloads once.
  3. Paste the whole file into the wizard.
  4. The wizard shows you the account's email address, something like sheets-bot@your-project.iam.gserviceaccount.com.
  5. Share every spreadsheet you want to use with that address, as an Editor.

Before you start

  • You need permission to manage integrations in WA.cr, and enough access in Google Cloud to create a project.
  • Google may charge you for heavy use of its APIs. Normal automation volumes sit inside the free allowance.
  • Keep the client secret and the key file private — treat them like a password.

If it doesn't work

  • "Google rejected the redirect URL" — the address in your OAuth client doesn't match. Copy it again from the wizard and paste it exactly.
  • It worked, then stopped after a week — your app is still in Testing. Publish it on the consent screen, then reconnect.
  • "The account can't open that spreadsheet" — a service account only sees files shared with it. Share the file with its email address as an Editor.
  • The spreadsheet list is empty — check that the Google Drive API is switched on for your project.
  • Press Test on the connection card at any time to check it and see the exact problem.