Google Sheets Integration¶

Connect a spreadsheet so Adwize can snapshot the tabs you pick on a schedule and write cells after you accept. Sheets is not a warehouse table and is not used for Hive ingest.

What Adwize can do¶

• Read the spreadsheet URL you paste (we do not browse Drive)
• Snapshot selected tabs
• Update cells with values.update after you accept an action

What Adwize does not do¶

• List or search Drive
• Ingest sheet rows as warehouse streams
• Publish GTM or change Ads/GA from this connector

Setup¶

On the Google Cloud project that owns the OAuth client, add the Sheets scopes and the Sheets callback URI. Connecting GTM first is not enough — Sheets uses its own token.

1. In Adwize, go to Settings > Integrations and open Google Sheets.
2. Click Connect with Google and grant spreadsheet access. If you already connected with only Tag Manager scopes, disconnect and connect again.
3. Paste the spreadsheet URL and click Load tabs.
4. Check every tab you want. One spreadsheet per connection; at most 20 tabs.
5. Click Save selected tabs. The snapshot is those tabs, all columns, and the first 10,000 rows per tab (header included).

When Adwize proposes a cell write, it stays pending until you click Accept. Until then, the sheet is unchanged.