Skip to main content
Available on: all plans (Starter, Growth, Scale and Enterprise).
Send every new funnel lead to a spreadsheet as a new row, with their answers, lead score (a Cold, Warm or Hot label based on their answers) and ad source. Google Sheets is the free spreadsheet app from Google. You connect it with your Google login. With the Google Sheets integration, you can:
  • Get every lead in a spreadsheet. No Zapier and no exports.
  • Share only what you choose. You pick the spreadsheet in Google’s own file picker, and AskFunnel can use only that file. It cannot see your other Google Drive files.
  • See every answer in its own column. Each question gets a column, plus the time, lead ID, funnel, score and where the lead came from. New questions get a column automatically.
  • Never lose a lead quietly. AskFunnel retries automatically, shows every lead in a delivery log, and emails you if something needs your attention.
Before you start, you need:
  • A Workspace Admin or Global Admin role. Only they can set up integrations.
  • A Google account that can edit the spreadsheet you want to use. You can also start from a blank spreadsheet. AskFunnel writes the column headers for you.
  • A funnel to connect. See Launch your first funnel.

​
Important to note

  • Each funnel sends its leads to one tab of one spreadsheet. Several funnels can share the same tab. The Funnel column tells them apart.
  • Keep the header in row 1. AskFunnel adds its headers to the right of yours and never changes the cells you already have.
  • Rows are added at the bottom in the order they are delivered. A lead that needed a retry can land below newer leads, so sort by Submitted at if the order matters.

​
Setup

1

Connect your Google account

  1. From your main dashboard, find the funnel you want to connect.
  2. Click the three small dots (…) on that funnel’s row, then click “Funnel Settings”.
  3. On the left side menu, click “Integrations”.
  4. Under Send leads to, on the Google Sheets card, click “Settings”.
  5. Click “Connect Google”. Your browser goes to Google.
  6. Sign in to Google if asked, choose the account that can edit your spreadsheet, and approve access. AskFunnel asks for your email address, to show which account is connected, and for access to only the spreadsheets you pick.
  7. Back in AskFunnel, the Google Sheets settings open with your account selected.
The Integrations menu item and the Settings link on the Google Sheets card, both highlighted
Approve every permission Google lists. If you skip one, AskFunnel asks you to allow every permission and connect again. Finish connecting in the same browser you started from.
2

Choose your spreadsheet and tab

  1. Next to Spreadsheet, click “Choose spreadsheet”. Google Drive’s file picker opens.
  2. Pick your spreadsheet. Spreadsheets in My Drive and in shared drives are both listed.
  3. Under Tab, choose the tab that should receive your leads.
  4. Include UTM parameters and referrer is on by default. Turn it off if you do not want those columns.
“Send test row” and “Save” turn on once a spreadsheet and a tab are chosen.The Google Sheets settings with the Google account, the spreadsheet and tab chosen, and the Change button highlighted
  • Only Google spreadsheets are listed. If your file is an Excel file, open it in Google Sheets and choose File, then Save as Google Sheets.
  • Only the person who connected a Google account can choose spreadsheets with it.
3

Test and save

  1. Click “Send test row”. AskFunnel adds a row for a sample lead named AskFunnel Test (test@askfunnel.test). Click “Open spreadsheet” next to the result to see it, then delete the row if you like.
  2. Click “Save”. AskFunnel writes its column headers into row 1 and starts sending leads.
The Google Sheets settings after a successful test, with Test row added, the Open spreadsheet link and the Save button highlightedAnd that’s it: every new lead now arrives as a row in your spreadsheet, with the time, every answer and the contact details.The Summit Realty Group leads spreadsheet in Google Sheets with a header row and one row per lead, showing when each lead arrived and their answers

​
How do I know it is working?

  • The Google Sheets card shows Connected and the name of your spreadsheet and tab.
  • In the Google Sheets settings, click “View delivery log”. Each lead shows Delivered, Retrying or Failed, and you can open a lead to see every attempt. Tests are listed as Test.
  • If Google cannot be reached, AskFunnel tries again after 1 minute, 5 minutes, 30 minutes, 2 hours, 6 hours and 12 hours. That is up to 7 attempts in about 21 hours.
  • If something needs your attention, the card shows Needs attention, and the organization owner gets an email.
The Google Sheets delivery log with delivered leads and one lead opened to show Row added to your spreadsheet

​
Troubleshooting

AskFunnel shows Google Drive didn’t open when the file picker is blocked. Allow pop-ups and scripts for dash.askfunnel.com, turn off any ad blocker for that site, then click “Try again”. If it still does not open, try another browser.
Only the person who connected a Google account can use it to pick spreadsheets. Open the Google account list, click “Connect another account” and sign in with your own Google account, then choose the spreadsheet.
Open the spreadsheet in Google Sheets, click Share, and give that Google account Editor access. Or ask the owner to do it. Then pick the spreadsheet again, or choose another one.
Open the lead in the delivery log to see the reason, fix it, then click “Retry”, or “Retry failed” to send all failed leads again. Common reasons:
  • The spreadsheet tab was deleted. Open the settings, choose another Tab and click “Save”.
  • The spreadsheet was deleted or is no longer shared with this Google account. Restore it or share it again, or click “Change” to choose another spreadsheet, then click “Save”.
  • This Google account can’t edit the spreadsheet. Give the account edit access in Google Sheets.
  • Too many columns. AskFunnel can write up to 250 columns to one sheet. Email us and we will help.
When you save new settings, leads that failed are sent again automatically.
Open the Google Sheets settings and click “Reconnect Google”. New leads are sent again right away, and leads that failed while access was broken are sent again too. Check the delivery log to see them arrive.
AskFunnel adds a column when you add a question to the funnel, and also when a header it uses was renamed or deleted in the sheet. If you renamed a header, change it back, then delete the extra column. To hide a column you do not want to see, use Google Sheets’ Hide column instead of deleting it.
This is rare. If Google does not confirm that a row was added, AskFunnel looks for the lead’s Lead ID in the newest 100 rows before trying again. If the Lead ID column was renamed or removed, or the row is further down than that, the lead can be added twice. Use the Lead ID column to find and delete the extra row.

​
What AskFunnel writes to your sheet

Each lead becomes one row. The columns are, in this order:
  1. Submitted at. The date and time of the submission, in UTC (standard world time), for example 2026-10-01T14:32:08.000Z.
  2. One column for each question in your funnel and each contact detail (name, email and phone), named after the question. Multiple choice answers are joined with commas.
  3. Lead ID. AskFunnel’s ID for the lead.
  4. Funnel. The name of the funnel.
  5. Score. The lead score.
  6. Marketing cookies. TRUE if the visitor accepted marketing cookies, FALSE if not.
  7. If Include UTM parameters and referrer is on: UTM source, UTM medium, UTM campaign, UTM term, UTM content and Referrer.
Your own columns are fine too. If your sheet already has a header that matches one of these (upper or lower case, extra spaces do not matter), for example Email, AskFunnel writes into that column. Headers it does not find are added to the right. You can move columns around, and columns you add yourself stay empty for new rows.
  • Do not rename or delete the headers AskFunnel uses. AskFunnel finds each column by its header. If a header is renamed or deleted, AskFunnel adds the original header again at the far right and writes new answers there.
  • If you rename a question in your funnel, the sheet keeps using the original header, so the answers stay in the same column.
  • A sheet can hold up to 250 columns.

​
Tracking where your leads come from

There is nothing to set up. UTM parameters are tags on your link (source, medium, campaign, term and content) that show where a visit came from. When someone lands on your funnel, AskFunnel captures them and the referrer (the page they came from) automatically. With Include UTM parameters and referrer on, they are written to the UTM columns and the Referrer column of each row.

​
Manage the integration

  • Pause it for one funnel: turn off the switch on the Google Sheets card. Leads that arrive while it is paused are not sent later.
  • Send to another spreadsheet or tab: open the Google Sheets settings, click “Change” next to Spreadsheet, or pick another Tab, then click “Save”. Rows already in the old spreadsheet stay there.
  • Remove it from one funnel: open the Google Sheets settings and click “Remove from funnel”. Your Google account stays connected.
  • Disconnect a Google account: in the Google Sheets settings, click “Manage accounts”, then “Remove” next to the account. You can also remove AskFunnel’s access yourself in your Google Account, at myaccount.google.com/permissions.
When you remove a Google account, AskFunnel asks Google to end its access, unless the same Google account is also connected in another AskFunnel workspace. Every funnel that uses the account stops sending leads to Google Sheets. If you connect the same Google account again later, those funnels start sending again and keep their spreadsheet choices, except any you paused yourself. Rows already in your spreadsheet stay there.

​
What to do next

Send leads to a webhook

Connect Zapier, Make, n8n or your own server.

Send leads to HighLevel

Every new lead becomes a contact in HighLevel.

Track your ads

Connect Meta Pixel to see which ads bring leads.
Need help? Email support@askfunnel.com.