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 three ways to connect, and the wizard asks you to choose first.

  • Sign in with Google — one button. You approve WA.cr on Google's own screen and you're done: nothing to create, nothing to copy. You then choose each spreadsheet from your Google Drive, in Google's own window, and WA.cr can open only the spreadsheets you choose there or that it creates for you. This is the one to use.
  • Use my own Google app — the same thing, but through an app you register in Google Cloud yourself, so the sign-in screen carries your own name. It needs a one-time setup of about ten minutes.
  • 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. If you take Sign in with Google, the next screen is Google's own — approve it and you're finished; skip the rest of this article.
  3. For the two advanced routes: 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 using your own Google app

  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.

Choosing a spreadsheet

How you pick a spreadsheet — in an Auto Flow step, or for sending orders to a sheet — depends on how you connected:

  • Signed in with Google — press Choose from Google Drive and pick the spreadsheet in Google's window. Picking it is what lets WA.cr open it, so a spreadsheet you've never picked stays out of reach. If a step names one WA.cr can't open yet, press Give access to this one.
  • Your own Google app or a service account — search for the spreadsheet by name in the list.

Spreadsheets WA.cr creates for you, with a Create a spreadsheet step, can always be opened — there's nothing to pick.

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 — on your own Google app, check that the Google Drive API is switched on for your project.
  • "Reconnect it under Integrations to choose one" — this Google account was connected before spreadsheets were chosen in Google's window. Press Reconnect on its card and approve again. Steps that already name a spreadsheet keep working until you do; afterwards, choose each one again once, with Give access to this one.
  • "This Google account can't open that spreadsheet yet" — you signed in with Google, and that spreadsheet hasn't been picked. Press Give access to this one and pick it.
  • "Google's file picker didn't load" — something in your browser, such as an ad blocker, is blocking Google's picker. Allow apis.google.com and docs.google.com, then try again.
  • Press Test on the connection card at any time to check it and see the exact problem.