Sending Form Submissions to Google Sheets Automatically | FilaForms [ ![Filaforms Logo](https://filaforms.app/logo.svg)FilaForms ](https://filaforms.app) [ Features ](https://filaforms.app#features) [ Documentation ](https://docs.filaforms.app) [ Blog ](https://filaforms.app/blog) [ Pricing ](https://filaforms.app#pricing) [ Try Demo ](https://filaforms.app/login) [ Get Started ](https://filaforms.app#pricing) [ Features ](https://filaforms.app#features) [ Documentation ](https://docs.filaforms.app) [ Blog ](https://filaforms.app/blog) [ Pricing ](https://filaforms.app#pricing) [ Try Demo ](https://filaforms.app/login) [ Get Started ](https://filaforms.app#pricing) ![FilaForms](https://filaforms.app/logo.svg) FilaForms IntegrationsSending Form Submissions to Google Sheets Automatically ======================================================= filaforms.app/blog [ Back to blog ](https://filaforms.app/blog) [ Integrations ](https://filaforms.app/blog/category/integrations) Sending Form Submissions to Google Sheets Automatically ======================================================= Manuk Minasyan · April 27, 2026 · 6 min read Your marketing person doesn't want to log into your admin panel. Your sales lead doesn't care about Filament. They want a spreadsheet. And honestly, that's a reasonable request. I've been on enough projects where someone says "can you just get the form data into a Google Sheet?" that I finally built a proper integration for it. FilaForms now connects directly to Google Sheets through OAuth, and every submission appends as a new row. No Zapier. No middleware. Just your form, a spreadsheet, and a checkbox to pick which fields go where. Here's how to set it up. [\#](#what-youll-need-before-starting "Permalink")What you'll need before starting ---------------------------------------------------------------------------------- - A working FilaForms installation (if you're starting fresh, the [contact form tutorial](https://filaforms.app/blog/building-a-contact-form-in-laravel-with-filament-step-by-step) covers setup from scratch) - A Google account with access to Google Cloud Console - Composer access on your server - About 15 minutes [\#](#install-the-integrations-package "Permalink")Install the integrations package ----------------------------------------------------------------------------------- The Google Sheets integration lives in a separate package. Pull it in with Composer: ``` composer require filaforms/integrations ``` That's it for the code side. The rest is configuration. [\#](#set-up-google-cloud-console "Permalink")Set up Google Cloud Console ------------------------------------------------------------------------- This is the longest part of the process, but it's straightforward if you follow it step by step. ### [\#](#create-a-project "Permalink")Create a project Go to [console.cloud.google.com](https://console.cloud.google.com) and create a new project. Name it something you'll recognize later, like "FilaForms Integration" or whatever makes sense for your app. ### [\#](#enable-the-apis "Permalink")Enable the APIs You need three APIs enabled on this project: - **Google Sheets API** (read/write spreadsheet data) - **Google Drive API** (browse spreadsheets in the picker) - **Google Picker API** (the popup that lets you visually select a spreadsheet) Search for each one in the APIs & Services library and click Enable. ### [\#](#create-oauth-20-credentials "Permalink")Create OAuth 2.0 credentials Go to APIs & Services > Credentials and create an OAuth 2.0 Client ID. Choose "Web application" as the type. Add your redirect URI: ``` https://your-domain.com/filaforms/connections/oauth/callback ``` If you're developing locally and using something like fwd.host to tunnel, you'll handle that differently (covered in the environment variables section below). Save the client ID and client secret. You'll need both. ### [\#](#create-an-api-key "Permalink")Create an API key Still in Credentials, create an API Key. Restrict it to the Google Picker API only. This key is used client-side for the spreadsheet picker popup, so restricting it limits exposure. [\#](#configure-environment-variables "Permalink")Configure environment variables --------------------------------------------------------------------------------- Add these to your `.env`: ``` FILAFORMS_GOOGLE_SHEETS_ENABLED=true FILAFORMS_GOOGLE_CLIENT_ID=your-id.apps.googleusercontent.com FILAFORMS_GOOGLE_CLIENT_SECRET=your-secret FILAFORMS_GOOGLE_API_KEY=your-api-key ``` If you're running locally with a tunnel service like fwd.host, add this too: ``` FILAFORMS_OAUTH_CALLBACK_URL=https://fwd.host/http://your-site.test/filaforms/connections/oauth/callback ``` On production, the callback URL is derived automatically from your app URL, so you don't need to set it explicitly. [\#](#connect-your-google-account "Permalink")Connect your Google account ------------------------------------------------------------------------- With the environment configured, go to the Integrations page in your Filament admin panel. You'll see an option to connect a Google account. Click it. You'll go through the standard Google OAuth flow: pick your account, grant permissions, and get redirected back. The integration requests three scopes: spreadsheet access (read/write), Drive access (read-only, just for browsing in the picker), and your email (to show which account is connected). Once connected, you'll see your Google account listed. The token refreshes automatically, so you won't need to reconnect unless you revoke access from Google's side. [\#](#add-the-integration-to-a-form "Permalink")Add the integration to a form ----------------------------------------------------------------------------- Open any form in FilaForms and go to its integration settings. Add a Google Sheets integration. Here's the flow: 1. Select your connected Google account from the dropdown 2. Click "Select a Google Spreadsheet" to open the Drive Picker popup 3. Pick any spreadsheet from your Google Drive. The popup closes automatically once you select one 4. Enter the sheet tab name (defaults to "Sheet1" if you leave it blank) 5. Use the checkboxes to select which form fields to include You can also include metadata fields alongside your form data: Submission ID, Date, IP Address, and User Agent. Useful if you want a complete audit trail in the spreadsheet. [\#](#field-mapping-and-transformations "Permalink")Field mapping and transformations ------------------------------------------------------------------------------------- The integration doesn't just dump raw data. It maps form fields to spreadsheet columns and lets you apply transformations to the data before it lands in the sheet. There are 16 transformations available: - Text formatting: `uppercase`, `lowercase`, `trim` - Type conversions: `boolean`, `number`, `integer`, `string` - Date formatting: `date_iso`, `date_us` - Array handling: `comma_separated`, `first_item`, `last_item`, `count` - Structured data: `json` - Or just `none` to pass the value through as-is You can also inject static values into specific columns, which is useful if you're sending data from multiple forms into the same spreadsheet and want a column that identifies the source form. If you've already set up [submission tracking](https://filaforms.app/blog/form-submission-tracking-and-analytics-in-laravel-without-third-party-tools) in FilaForms, this pairs well with it. The tracking gives you analytics inside your app, and the Sheets integration gives your team a live data feed they can filter, sort, and chart without touching your codebase. [\#](#test-it "Permalink")Test it --------------------------------- Submit your form. Check the spreadsheet. You should see a new row with the fields you selected, formatted according to whatever transformations you picked. If the row doesn't appear, the issue is almost always one of the problems below. [\#](#troubleshooting "Permalink")Troubleshooting ------------------------------------------------- **Picker popup doesn't open.** Make sure you've selected a connected Google account from the dropdown first. The picker needs an active connection to authenticate against. **"Invalid API key" error in the picker.** You probably haven't restricted your API key to the Google Picker API, or the Picker API isn't enabled on your Google Cloud project. Go back to the Cloud Console, check both. **404 on the OAuth redirect.** The redirect URI in your Google Cloud Console doesn't match the one your app is generating. Double-check that you've added exactly `https://your-domain.com/filaforms/connections/oauth/callback` in your OAuth client settings. **Redirect URI mismatch error.** Same root cause as above but Google catches it before the redirect happens. Copy the exact URI from the error message and add it to your OAuth client's authorized redirect URIs. **Missing scopes or permission errors.** Disconnect your Google account from the Integrations page and reconnect. This forces a fresh OAuth flow that requests all the required scopes. **Data not appearing in the sheet.** Check that you've entered the correct sheet tab name. If your spreadsheet's first tab isn't called "Sheet1" (maybe you renamed it), the integration won't find it silently. [\#](#why-not-zapier "Permalink")Why not Zapier? ------------------------------------------------ You could use Zapier or Make for this. But then you're adding a third-party service, a monthly bill, and a failure point you can't debug from your own server. The FilaForms integration runs inside your app. If something breaks, you can see what happened in your logs. For teams that already live in Google Sheets for reporting, this removes the gap between "form submitted" and "data available." No webhook relay, no extra service to keep an eye on. If you haven't set up FilaForms yet, the [quickstart guide](https://filaforms.app) walks you through installation in a few minutes. Related posts ------------- [ Integrations Apr 20, 2026 Collecting Payments with Stripe Connect in FilaForms ------------------------------------------------------ Sometimes a form needs to collect money, not just data. Registration fees, order payments, donation amounts. If you're running FilaForms on your own server, you probably don't want to bolt on a separate payment system and duct-tape it to your form submissions. Stripe Connect lets you handle the w... ](https://filaforms.app/blog/collecting-payments-with-stripe-connect-in-filaforms) ![FilaForms Logo](/logo.svg) FilaForms Laravel form infrastructure for Filament. Stop rebuilding forms on every project. ### Product [ Features ](https://filaforms.app#features) [ Documentation ](https://docs.filaforms.app) [ Blog ](https://filaforms.app/blog) [ Pricing ](https://filaforms.app#pricing) [ Contact ](mailto:hello@filaforms.app) ### Legal [ Terms of Service ](https://filaforms.app/terms-of-service) [ Privacy Policy ](https://filaforms.app/privacy-policy) © 2025-2026 FilaForms. All rights reserved. [ ](mailto:hello@filaforms.app) [ ](https://x.com/MinasyanManuk)