# How do I send Evaboot leads to Google Sheets? **Connect Google from the Integrations page, then pick a mode for your spreadsheets.** Evaboot creates the spreadsheets in your Google Drive and writes each export into them. ## Before you start - A Google account. You sign in to Google and approve Evaboot's access on Google's own page. - Evaboot can only see and edit the spreadsheets it creates for you. It cannot read anything else in your Drive, so it cannot write into a spreadsheet you made yourself. ## Connect Google Sheets 1. **Open [Integrations](https://dash.evaboot.com/dash/integrations/)** and click **New integration**. If you have no integration yet, the tool cards show on the page directly. ![The Integrations page of the Evaboot dashboard with a card for each tool](https://help.evaboot.com/images/flows/manual-integrations/00-integrations.png) 2. **Click the Google Sheets card**, then **Connect Google Sheets**. ![The Connect Google Sheets page in the Evaboot dashboard](https://help.evaboot.com/images/flows/manual-integrations/google-sheets-connect.png) 3. **Approve the access** on the Google page. You come back to the **Google Sheets settings** page, which shows the Google account you connected. ## Choose the settings 4. **Name the integration.** 5. **Pick a Mode.** - **New tab per export**: one spreadsheet. Each export lands in its own tab. - **New spreadsheet per export**: a separate spreadsheet for every export. - **One running sheet**: every export adds rows to the same sheet, with an export-name column. Leads already in the sheet are skipped. 6. **Pick what to send** under **Send data from**: Sales Navigator exports, URL enrichment, Email finder or Email verifier. 7. **Set the filters.** - **Email filter**: All emails, Safe emails only, or Found emails only. - **Qualification filter**: All prospects, or Qualified only. 8. **Pick the trigger.** - **Automatic: send when a job completes**: each finished, unlocked export is sent. Under **Send leads from**, choose all exports, all recurring exports, specific recurring exports, or specific folders. - **Manual: only send when you trigger it**: nothing is sent until you push an export yourself. 9. **Click Save.** The integration appears on the Integrations page. ## Where your leads land | Mode | Spreadsheet name | Tab | | --- | --- | --- | | New tab per export | `Evaboot exports` | One tab per export, named after the export. An `About` tab comes first. | | New spreadsheet per export | `Evaboot: ` | `Leads`, or `Accounts` for an account export | | One running sheet | `Evaboot leads` | `Leads`, or `Accounts` for account exports | - The columns are the same as your CSV download. - In a running sheet, Evaboot adds an `Export Name` column. A lead is skipped when its `Linkedin URL Unique ID` is already in the sheet. Accounts use `Company Linkedin URL Unique ID`, email jobs use `Email`. - In the two per-export modes, pushing the same export again rewrites its tab or spreadsheet. It does not add a second copy. - Values are written as plain text, never as formulas. - When a spreadsheet reaches Google's cell limit, Evaboot starts a new one with the same name plus a number, like `Evaboot leads 2`. - If you delete the spreadsheet, Evaboot creates a new one on the next push. ## Send an export by hand On the export list, click **+** in the **Push** column of a finished export (**Push this export**) and pick your Google Sheets integration. The export must be unlocked first. Click the Google Sheets logo in the same cell to see the push log. To send every run of a recurring export, pick the integration under **Send new leads to** when you set the schedule up. ## If it didn't work - **"Google Sheets connection was cancelled or failed"**: the approval on Google did not finish. Click **Connect Google Sheets** again. - **Reconnect shows in the Status column**: Google no longer accepts the connection. Click **Reconnect** and approve the access again. - **"Google Sheets is not responding"**: wait a few minutes and try again. - **You can't find the spreadsheet**: search your Google Drive for the spreadsheet name in the table above. - **A lead is missing from a running sheet**: it was already in the sheet from an earlier export, so it was skipped. ## Related articles - [How Do I Send My Evaboot Results to Other Tools?](https://help.evaboot.com/public/integrations/what-is-evaboot-integration-and-how-does-it-work/) - [How Do I Set Up My Zapier Integration?](https://help.evaboot.com/public/integrations/how-do-i-set-up-my-zapier-integration/) - [How Do I Send Evaboot Results to a Webhook?](https://help.evaboot.com/public/integrations/how-do-i-set-up-a-webhook-integration/)