Google Sheets Integration

Overview

The Google Sheets flow node lets you append rows to a spreadsheet (e.g. log a lead) or look up a row by matching a column value, then map the result onto flow variables. The node reads its target file through a Drive picker populated from your account, so you select the file by name rather than pasting IDs.

Additionally, WA Orbit ships a Google Sheets Add-on that lets you build and manage your WhatsApp storefront straight from a spreadsheet — one row per product.

Google Sheets Flow Node

Connecting Google enables the Sheets node in the visual flow builder. Each node reads its target file through a Drive picker, so you select the spreadsheet by name.

• Append a row — log a lead, record an interaction, or track any data point to your spreadsheet.
• Look up a row — match a column value (e.g. phone number or email) and map the result onto flow variables.

Google Sheets Add-on (WhatsApp Storefront)

Separate from the flow node, the Sheets Add-on lets you manage your WhatsApp store from a spreadsheet. Find it under More → Integrations → Sheets Add-on.

Step 1 — Generate Your Sheets API Key

On the Sheets Add-on page, click Generate API key. You get a key (looks like wsn_live_...), shown only once — copy it right away. You can revoke or regenerate it from the same page anytime.

Step 2 — Install the Add-on Script

Two routes:

• Marketplace — install from the Google Workspace Marketplace in one click.
• Manual — create a new Apps Script project at script.google.com and copy in the files WA Orbit provides.

Step 3 — Use It in a Sheet

1. Open any Google Sheet, then Extensions → [Your app] WhatsApp Shop → Open.
2. Paste your API key into the add-on's Settings sidebar.
3. The sidebar lists your existing shops and lets you create a new shop from the sheet's rows — one product per row.

Prerequisites

The Google Sheets integration is part of the Google Workspace connection. You need:

• The Google Sheets API enabled in your Google Cloud project.
• The auth/spreadsheets scope granted during Google account connection.
• The auth/drive scope for the file picker to list your spreadsheets.