Title: Connect Google Sheets | OneForm > Add a row to a Google Sheet for every response, or keep a sheet of your leads with their scores. Source: https://oneform.si/help/integrations/google-sheets/ --- 1. [Help Center](https://oneform.si/help/) 2. [Integrations](https://oneform.si/help/integrations/) 3. Connect Google Sheets [View as Markdown](https://oneform.si/help/integrations/google-sheets.md) # Connect Google Sheets Add a row to a Google Sheet for every response, or keep a sheet of your leads with their scores. [Basic plan and up](https://oneform.si/pricing/ "See what each plan includes")Admins and ownersUpdated October 22, 2026 · 2 min read [Connect Google Sheets ↗](https://app.oneform.si/integrations?open=google-sheets&help=google-sheets) Google Sheets gives you a running log of every response, in a spreadsheet you can sort, share and chart. You can also keep a sheet of your leads, one row per person, with their lead score. ## Connect Google Sheets ![The Google Sheets panel on the Integrations page, with the Connect Google button](https://app.oneform.si/media/0741bfef-8de4-5de2-a4a0-8fbe16f878f2) 1. Go to [Integrations](https://app.oneform.si/integrations?open=google-sheets). The Google Sheets panel opens. 2. Click **Connect Google**. 3. Choose your Google account and allow the access Google asks for. 4. You're back in OneForm, and the Google account is connected. If your Google account is already connected for something else, click **Allow** next to **Sheets** on its card instead. ## Log every response 1. Open [Workflows](https://app.oneform.si/workflows) and open the workflow you want, or start one from the **Log every response to Google Sheets** recipe. 2. Click **+** (**Add an action**) and choose **Add a row in Google Sheets**. 3. Under **Google account**, choose the account. 4. Click **Create a new spreadsheet**, or **Choose from Google Drive** to use one you have. 5. Type the **Tab** name. OneForm creates the tab if it doesn't exist. 6. Under **Columns**, keep **Every answer**, or pick **Choose columns** and set each column's value. 7. Click **Test it**, then **Turn on** (or **Save and turn on**). With **Every answer**, each row has the date, name, email, one column per question, scores, the report status and a review link. When you add a question to the form, OneForm adds a column for it. ## Keep a lead list - **From a workflow:** add **Keep a lead list in Google Sheets** and choose **Which leads**: **Everyone**, **Warm & hot**or **Hot only**. - **From the Leads page:** click **Export**, then the **Google Sheets** entry under **Send to your CRM or a sheet**. The first time, pick or create the sheet. Each lead gets one row, and sending them again updates that row instead of adding another. See [Send leads to your CRM](https://oneform.si/help/responses-and-leads/send-leads-to-your-crm/). ## What OneForm can see Only the spreadsheets OneForm creates and the ones you pick in Google's file picker. It can't open anything else in your Drive. The access is stored encrypted. ## Disconnect Google Sheets On the [Integrations](https://app.oneform.si/integrations) page, click **Manage** on the Google card, then **Disconnect**. This removes the whole Google account, so Drive, Calendar and Chat stop working for it too. OneForm also gives up its access in your Google account, unless another OneForm firm still uses that account. Your spreadsheets stay in your Drive. ## Why can't I find my existing spreadsheet? OneForm can only use a sheet you choose in Google's picker. Click **Choose from Google Drive** and pick it there, from the same Google account you connected. ## Why did rows stop arriving? - The spreadsheet was deleted, or the connected account lost access to it. Choose the sheet again in the action. - Google access was removed or expired. The Google card moves to **Needs attention**; click **Reconnect**. See [An app stopped sending](https://oneform.si/help/troubleshooting/an-app-stopped-sending/). Was this article helpful? [← PreviousConnect Discord](https://oneform.si/help/integrations/discord/)[Next →Connect Microsoft Excel](https://oneform.si/help/integrations/microsoft-excel/) ## Related articles [Connect OneForm to your other appsHow the Integrations page works, how one-click connecting works, which apps your plan includes, and how to disconnect.Basic plan and up](https://oneform.si/help/integrations/integrations-overview/)[Connect Microsoft ExcelAdd a row to an Excel workbook in your OneDrive for every response, or keep a workbook of your leads with their scores.Basic plan and up](https://oneform.si/help/integrations/microsoft-excel/)[Connect Google DriveSave every report PDF into a Google Drive folder, with a sub-folder per client if you like, or send finished reports in one go.Pro plan and up](https://oneform.si/help/integrations/google-drive/)[Responses and leadsSend leads to your CRMSend people from the Leads page to HubSpot, Salesforce, Pipedrive, Zoho CRM, Google Sheets or Excel, with their score and why.Pro plan and up](https://oneform.si/help/responses-and-leads/send-leads-to-your-crm/) Still stuck? A person on the OneForm team reads every request. Mon–Fri, 9am–6pm ET. First reply within 1 business day. [Open a support case](https://oneform.si/contact/?topic=support)[Report a bug in the app](https://app.oneform.si/ideas?view=feedback)[hello@oneform.si](mailto:hello@oneform.si?subject=OneForm%20support) [Overview](https://oneform.si/help/) Topics - [Getting started](https://oneform.si/help/getting-started/) - [Forms](https://oneform.si/help/forms/) - [Sharing and embeds](https://oneform.si/help/share/) - [Responses and leads](https://oneform.si/help/responses-and-leads/) - [Reports](https://oneform.si/help/reports/) - [Payments](https://oneform.si/help/payments/) - [Bookings](https://oneform.si/help/bookings/) - [Workflows](https://oneform.si/help/workflows/) - [Integrations](https://oneform.si/help/integrations/) - [Connect OneForm to your other apps](https://oneform.si/help/integrations/integrations-overview/) - [Connect Slack](https://oneform.si/help/integrations/slack/) - [Connect Microsoft Teams](https://oneform.si/help/integrations/microsoft-teams/) - [Connect Google Chat](https://oneform.si/help/integrations/google-chat/) - [Connect Discord](https://oneform.si/help/integrations/discord/) - [Connect Google Sheets](https://oneform.si/help/integrations/google-sheets/) - [Connect Microsoft Excel](https://oneform.si/help/integrations/microsoft-excel/) - [Connect Google Drive](https://oneform.si/help/integrations/google-drive/) - [Connect OneDrive](https://oneform.si/help/integrations/onedrive/) - [Connect HubSpot](https://oneform.si/help/integrations/hubspot/) - [Connect Pipedrive](https://oneform.si/help/integrations/pipedrive/) - [Connect Salesforce](https://oneform.si/help/integrations/salesforce/) - [Connect Zoho CRM](https://oneform.si/help/integrations/zoho-crm/) - [Send workflow emails from your Outlook mailbox](https://oneform.si/help/integrations/send-email-from-outlook/) - [Connect Google Calendar and Google Meet](https://oneform.si/help/integrations/google-calendar-and-meet/) - [Connect Outlook Calendar and Teams meetings](https://oneform.si/help/integrations/outlook-calendar-and-teams-meetings/) - [Send data to another app with webhooks](https://oneform.si/help/integrations/send-data-to-another-app-webhooks/) - [Connect Claude, ChatGPT and other AI agents](https://oneform.si/help/integrations/connect-ai-agents/) - [Move your leads into TaxDome](https://oneform.si/help/integrations/taxdome/) - [Emails and notifications](https://oneform.si/help/emails-and-notifications/) - [Team and account](https://oneform.si/help/team-and-account/) - [Plans and billing](https://oneform.si/help/billing/) - [Privacy and security](https://oneform.si/help/privacy-and-security/) - [Troubleshooting](https://oneform.si/help/troubleshooting/) For your clients - [For your clients](https://oneform.si/help/for-clients/) [Glossary](https://oneform.si/help/glossary/)[FAQ](https://oneform.si/help/faq/)[Developer docs](https://oneform.si/developers/)[Contact support](https://oneform.si/contact/?topic=support)