Google Sheets

Automatically add form submissions to Google Sheets

Send form submissions directly to a Google Sheets spreadsheet.

Setup Steps

1. Create a Google Sheet

   1. Go to Google Sheets
   2. Create a new spreadsheet
   3. Add column headers in the first row matching your form fields
   4. Example: Name, Email, Message, Submitted At
2. Create a Google Apps Script

   1. In your spreadsheet, go to Extensions → Apps Script
   2. Delete any existing code
   3. Paste the following script:

   function doPost(e) {
     const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
     const data = JSON.parse(e.postData.contents);
     
     // Get headers from first row
     const headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];
     
     // Create row based on headers
     const row = headers.map(header => {
       const key = header.toLowerCase().replace(/\s+/g, '_');
       return data[key] || data[header] || '';
     });
     
     // Add timestamp if column exists
     const timestampIndex = headers.findIndex(h => 
       h.toLowerCase().includes('submitted') || h.toLowerCase().includes('timestamp')
     );
     if (timestampIndex !== -1) {
       row[timestampIndex] = new Date().toISOString();
     }
     
     sheet.appendRow(row);
     
     return ContentService.createTextOutput(JSON.stringify({success: true}))
       .setMimeType(ContentService.MimeType.JSON);
   }
   
3. Deploy the Script

   1. Click Deploy → New deployment
   2. Click the gear icon → Web app
   3. Set Execute as: “Me”
   4. Set Who has access: “Anyone”
   5. Click Deploy
   6. Authorize the app when prompted
   7. Copy the Web app URL
4. Configure in Spike

   1. Go to your Spike Dashboard
   2. Select your form → Settings
   3. Scroll to Integrations → Google Sheets
   4. Enable the toggle
   5. Paste your Apps Script Web app URL
   6. Save changes

Column Mapping

The script automatically maps form fields to columns:

Form Field	Column Header
name	Name
email	Email
message	Message
Any field	Matching header

Column headers are case-insensitive and spaces are converted to underscores for matching.

Adding a Timestamp

Add a column called “Submitted At” or “Timestamp” to automatically record when each submission was received.

Troubleshooting

Data not appearing

• Verify the Apps Script URL is correct
• Check that the script is deployed as a web app
• Ensure “Anyone” has access to the web app
• Check the Apps Script execution logs for errors

Wrong columns

• Column headers must match form field names
• Headers are case-insensitive
• Spaces in headers are matched to underscores in field names

Authorization errors

• Re-deploy the script and re-authorize
• Make sure you’re using the correct Google account

Advanced: Custom Field Mapping

Modify the Apps Script to customize how fields are mapped:

function doPost(e) {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  const data = JSON.parse(e.postData.contents);
  
  // Custom mapping
  const row = [
    data.name || '',
    data.email || '',
    data.phone || '',
    data.message || '',
    new Date().toISOString()
  ];
  
  sheet.appendRow(row);
  
  return ContentService.createTextOutput(JSON.stringify({success: true}))
    .setMimeType(ContentService.MimeType.JSON);
}