# Google Sheets

Automatically sync your Web3Forms submissions to a Google Sheets spreadsheet in real-time. This integration is perfect for organizing, analyzing, and sharing form data with your team.

{% hint style="info" %}
This is a **PRO feature** currently in **Beta**. You must have an active PRO plan subscription to use this integration.
{% endhint %}

## Features

* ✅ **Real-time Sync**: Form submissions are automatically added to your spreadsheet
* ✅ **Easy Setup**: Connect with just a few clicks using Google OAuth
* ✅ **Flexible Configuration**: Choose which spreadsheet and sheet to use
* ✅ **Automatic Headers**: Column headers are created based on your form fields
* ✅ **No Code Required**: No scripts or API keys needed

## Setup Instructions

### Step 1: Access the Integrations Tab

1. Log in to your [Web3Forms Dashboard](https://app.web3forms.com)
2. Select the form you want to connect
3. Navigate to the **Integrations** tab in your form settings

### Step 2: Enable Google Sheets Integration

1. Find the **Google Sheets** integration card
2. Click "Connect" enable the integration
3. You'll be prompted to sign in with your Google account
4. Grant Web3Forms permission to access your Google Sheets

### Step 3: Configure Sheet Settings

**Spreadsheet Selection**

* Click the **Select** button to choose your destination spreadsheet
* You can select any existing spreadsheet in your Google Drive

**Sheet Name (Optional)**

* Enter the name of the sheet where data should be added
* Leave empty to use the default sheet (Sheet1)

<figure><img src="https://4078640192-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MPUC7SfrK7-rhtC1UKR%2Fuploads%2F2LjEjyErqzFW8868KXY0%2FCleanShot%202025-12-22%20at%2020.43.49%402x.png?alt=media&#x26;token=f1b9dd70-57c6-4eed-921b-1b8bbce216a7" alt=""><figcaption></figcaption></figure>

### Step 5: Save Settings

Click the **Save Settings** button to activate the integration.

## How It Works

1. When a user submits your Web3Forms contact form, the data is processed
2. Web3Forms automatically sends the submission to your connected Google Sheets
3. A new row is added with all the form field data
4. Column headers are created based on your form field names (if not already present)

### Data Format

Each submission creates a new row with the following information:

* **Timestamp**: Date and time of submission
* **Form Fields**: All custom fields from your form (name, email, message, etc.)

## Example Spreadsheet Structure

Here's how your data might look in Google Sheets:

| Timestamp           | Name       | Email              | Message               | Phone       |
| ------------------- | ---------- | ------------------ | --------------------- | ----------- |
| 2025-12-22 10:30 AM | John Doe   | <john@example.com> | Hello, I need help... | +1234567890 |
| 2025-12-22 11:45 AM | Jane Smith | <jane@example.com> | I have a question...  | +0987654321 |

## Managing Your Integration

### Disconnect Google Sheets

To stop syncing submissions to Google Sheets:

1. Go to your form's Integrations tab
2. Find the Google Sheets integration
3. Click the **Disconnect** button

### Change Spreadsheet

To use a different spreadsheet:

1. Click the **Select** button again
2. Choose a new spreadsheet from your Google Drive
3. Update the sheet name if needed
4. Click **Save Settings**

## Troubleshooting

### No Data Appearing in Spreadsheet

* **Check Integration Status**: Ensure the toggle is enabled and shows "Connected"
* **Verify Sheet Name**: Make sure the sheet name matches exactly (case-sensitive)
* **Check Permissions**: Ensure Web3Forms has access to your Google account
* **Test Your Form**: Submit a test entry and check if it appears

### Permission Errors

If you see permission errors:

1. Disconnect the integration
2. Reconnect and re-authorize your Google account
3. Make sure the spreadsheet isn't restricted or protected

### Data Not Formatting Correctly

* Column headers are created from form field names
* Make sure your form fields have descriptive `name` attributes
* Avoid special characters in field names for best results

## Privacy & Security

* Web3Forms uses secure OAuth 2.0 for Google account authentication
* Only necessary permissions are requested (selected spreadsheet access only)
* Your access tokens are encrypted and stored securely.
* You can revoke access anytime from your [Google Account Settings](https://myaccount.google.com/permissions)

## Related Integrations

* [Webhook Integration](https://docs.web3forms.com/getting-started/pro-features/webhooks) - Send data to custom endpoints
* [Zapier Integration](https://docs.web3forms.com/getting-started/integrations/soon/zapier) - Connect with 5,000+ apps
* [Airtable Integration](https://docs.web3forms.com/getting-started/integrations/soon/airtable) - Alternative database solution