---
title: "Google Sheets Integration for AgendaForge Events"
description: "Sync AgendaForge contacts and sponsors to a Google Sheet you choose: rows append, update, or delete on their own. Per-event setup, column mapping, six triggers."
canonical: "https://agendaforge.app/integrates-with/google-sheets"
last-updated: 2026-07-01
---
# Google Sheets Integration for AgendaForge Events
> Sync AgendaForge contacts and sponsors to a Google Sheet you choose: rows append, update, or delete on their own. Per-event setup, column mapping, six triggers.
Canonical page: https://agendaforge.app/integrates-with/google-sheets
Last reviewed or updated: 2026-07-01
Content type: integration

The AgendaForge Google Sheets integration keeps a spreadsheet of your contacts and sponsors current without anyone touching it. When a contact or sponsor is added, edited, or removed inside AgendaForge, the matching row in your sheet is appended, rewritten, or deleted to follow along. You connect Google once for the whole organization, pick the exact spreadsheet through the Google Picker, then map AgendaForge fields to columns on a per-event basis — so each event can feed its own file or its own tab with its own layout. It is genuinely wired: OAuth install, file selection, column mapping, and six automated triggers, not a someday promise. And because we use Google's drive.file scope, AgendaForge only ever touches the one sheet you hand it — never the rest of your Drive.

Official integration website: https://workspace.google.com/products/sheets/

## What it does

- Appends a new row to your chosen Google Sheet when a contact or sponsor is added in AgendaForge, writing each mapped field to its column.
- Rewrites the existing row in place when a contact or sponsor is updated, matched by a hidden ID column so the same record never duplicates.
- Deletes the row when a contact or sponsor is removed, keeping the sheet a faithful mirror of your directory.
- Connects once via Google OAuth, then is configured per event — you pick the spreadsheet through the Google Picker and map AgendaForge fields to specific columns.
- Touches only the file you select. The drive.file scope means AgendaForge can read and write the sheet you chose and nothing else in your Drive.

## Trigger and result

| Event | Result |
|---|---|
| contact.added | Appends a new row for the contact, writing each mapped field to its column and stamping the record ID into the hidden ID column. |
| contact.updated | Finds the contact's row by its ID column and rewrites it in place — so edits in AgendaForge never leave stale or duplicate rows behind. |
| contact.removed | Locates the contact's row by ID and deletes it, keeping the sheet an accurate reflection of your live directory. |
| sponsor.added | Appends a new row for the sponsor with mapped fields and the hidden ID, ready for your sponsorship tracking. |
| sponsor.updated | Matches the sponsor's row by ID and overwrites it, so tier changes and edits flow straight into the sheet. |
| sponsor.removed | Deletes the sponsor's row by ID match, leaving the spreadsheet in sync with what's actually in AgendaForge. |

## Setup

1. **Connect Google to your organization.** In Event Settings → Integrations → Google Sheets, click Connect and authorize AgendaForge. This is a one-time, org-wide OAuth step that grants the drive.file scope only — never your full Drive.
2. **Pick the exact spreadsheet.** Use the Google Picker to choose the specific spreadsheet AgendaForge should write to. Because of drive.file, only the sheet you select here becomes reachable; the rest of your Drive stays untouched.
3. **Map columns and turn on triggers.** Map AgendaForge contact and sponsor fields to spreadsheet columns for this event, then enable the added, updated, and removed triggers you want so rows append, rewrite, and delete on their own.

## Good to know

This integration is narrower than our Slack and ClickUp connectors: it covers contacts and sponsors only — not sessions or form submissions — and it flows one way, AgendaForge → Sheet. Editing a row directly in Google Sheets does not write back to AgendaForge; the sheet is a mirror of your directory, not a two-way sync.
## Frequently asked questions

### Which records can AgendaForge sync to Google Sheets?

Contacts and sponsors only — each on added, updated, and removed, for six triggers total, mapped to append-row, update-row, and delete-row. Sessions and form submissions are not part of this integration; for a wider set of triggers, reach for our Slack and ClickUp connectors instead.

### Will AgendaForge be able to see my whole Google Drive?

No. We request Google's drive.file scope, which only grants access to files you explicitly select through the Google Picker. AgendaForge can read and write the one spreadsheet you choose during setup and has no visibility into anything else in your Drive.

### How does it avoid creating duplicate rows?

Each synced row carries the record's ID in a hidden ID column. On an update or delete, AgendaForge finds the row by that ID and rewrites or removes it in place, so the same contact or sponsor never ends up duplicated even after repeated edits.

### Is the sync two-way? Can I edit the sheet and update AgendaForge?

No. The flow is one way: AgendaForge → Google Sheets. Changes you make directly in the spreadsheet do not write back to AgendaForge. Treat the sheet as a live mirror of your contacts and sponsors, not a place to edit them.

### Is Google Sheets configured per event or per organization?

Both. You authorize Google once for your whole organization, then choose the spreadsheet and map columns on a per-event basis — so each event can feed its own file or tab with its own column layout and active triggers.

---

AgendaForge is an AI-native event-management platform. Public machine-readable index: https://agendaforge.app/api/ai