Skip to content

Google Sheets Integration

Automatically send form submissions to Google Sheets for easy data management and analysis.

Setup

Step 1: Connect Your Account

  1. Log in to your Basin account.
  2. Navigate to the form you wish to integrate with Google Sheets.
  3. Go to Integrations and click Google Sheets.
  4. Click on Connect Account (or the Google Sign-In button) and authorize Basin to access your Google Sheets.

Step 2: Select a Spreadsheet and Sheet

  1. Once connected, click Select Spreadsheet to choose the file where you want to send your submissions.
  2. After selecting a spreadsheet, choose a specific Sheet Name from the dropdown menu.
  3. Click Save Changes to activate the integration.

Configuration Options

Auto-sync Column Mappings

When Automatically add new form fields is enabled: - Basin will automatically detect new fields in your form submissions and add them as new columns in your Google Sheet. - Manual deletion of column mappings in the Basin dashboard is disabled to ensure consistency between your form and the spreadsheet. - We recommend only re-ordering columns or turning off auto-sync if you need manual control over your header row.

Control how file attachments are shared in your Google Sheet:

  • When enabled (Use secure attachment links): Attachment links will direct to the submission page in Basin, which requires login to access. This provides better security by keeping file attachments behind authentication.
  • When disabled: Direct download links will be provided that anyone with the URL can access.

This setting is disabled by default. Enable it if you want to add an extra layer of security to your file attachments.

Submission Filters

You can choose which submissions are sent to your Google Sheet: - Include non-spam submissions: Sync all verified submissions (enabled by default). - Include spam submissions: Optionally sync submissions flagged as spam for review.

Manual Column Mappings

If auto-sync is disabled, you can manually map form fields to specific columns in your Google Sheet (e.g., Column 1 = Column A, Column 2 = Column B). Even with auto-sync enabled, you can use manual mappings for custom ordering.

Note: Google Sheets integration is available on Standard and higher plans.