Back to Changelog

Introducing Automatic Column Sync for Google Sheets

January 06, 2026

We’ve shipped Google Sheets Auto-Sync, a smarter way to keep your spreadsheet data perfectly aligned with your form submissions. Instead of manually mapping every new field, Basin now intelligently detects changes to your form and automatically adds corresponding columns to your Google Sheet in real-time.

What’s New?

  • Automatic Column Addition: New fields from form submissions are automatically detected and added as headers to your spreadsheet.
  • Dynamic Header Management: No more broken integrations or missing data when you add a new "Message" or "Phone" field to your form.
  • Flexible Controls: Toggle auto-sync on or off under Forms → [Your Form] → Integrations → Google Sheets.

How It Works

When Google Sheets Auto-Sync is enabled for a form:

  1. You add a new field to your form (e.g., <input name="budget" ...>).
  2. A user submits the form with the new data.
  3. Basin detects the new "budget" field and checks your connected Google Sheet.
  4. If a "budget" column doesn't exist, Basin:
    • Appends a new column header to the end of your spreadsheet.
    • Automatically maps the submission data to that new column.
    • Ensures all future submissions populate the correct field without manual intervention.

Why Use Auto-Sync?

Spreadsheets should work for you, not the other way around:

  • Save Time: Skip the manual mapping step every time you iterate on your form fields.
  • Eliminate Errors: Prevent data gaps caused by forgetting to update your integration after a form change.
  • Maintain Consistency: Ensure your headers always reflect the actual data being collected by your form.

Ready to Sync?

Go to your form’s Integrations → Google Sheets section to enable "Automatically add new form fields" and let Basin handle the heavy lifting for you.

You can also view our updated docs at https://docs.usebasin.com/integrations/google-sheets/