Skip to main content
All CollectionsIntegrationsNative Integrations
Google Sheets integration with Woodpecker
Google Sheets integration with Woodpecker

Google sheets have been natively integrated with Woodpecker now, which means there is no more need to export and import files.

Weronika Wróblewska avatar
Written by Weronika Wróblewska
Updated over a week ago

IN THIS ARTICLE

1. How does it work?

Woodpecker will connect with your Google Account and gain access to your Google Sheets saved on Google Drive.

Then, you can prepare a spreadsheet with prospects and instead of downloading it as a CSV file and importing it back to Woodpecker, you can move prospects between two applications with just a few clicks.

Image with description about Google Sheets integration with Woodpecker

Google Sheets Integration is a part of an API Key and Integrations add-on, click here to learn how to get it on Marketplace »


2. How do I connect my Google Account?

  1. Log in to your Woodpecker account.

  2. Go to Settings → MarketplaceIntegrations.

  3. Click on the icon with the Google Sheets logo:

Image with arrows poitnting to Google Sheets integration under Marketplace

4. Connect with your Google Account:

Image with arrow poitnting to a 'Connect' button on the Google Sheets integration page

5. Allow Woodpecker to access your Google Account:

Image with the access page from Google

Remember to check the box next to "See and download all your Google Drive files", as this integration won't work without it.

Connecting Google Account isn’t going to add your email address associated with it to Woodpecker for sending. Here is our guide on how to connect Gmail to Woodpecker »

Now that you have successfully connected your Google Account to Woodpecker you can transfer prospects from your Google Sheets.


3. How do I add prospects from Google Sheets to Woodpecker?

After connecting with your Google Account, click on the “Show” icon next to your login. You’ll see all the spreadsheets that Woodpecker was able to find and from which you can import prospects.

Remember that the file with your prospects must be in the "Shared with me" folder.

Image with the icon for a list highlighted

Choose a spreadsheet that you would like to import from and choose whether you want to upload your prospect to the main prospect base or straight to a certain campaign. The spreadsheet with your prospects' data should be in the first Sheet of the selected file.

Image showing two options to import prospects to Woodpecker from Google Sheets

If you want to choose a specific worksheet from your file, you can do so by clicking on the "Add to Woodpecker" icon next to the name of your Spreadsheet.

You will be transferred to the screen with the option to choose the worksheet from a list. Select the one you are interested in and click the "Continue" button.

The rest of the process looks the same as importing prospects from a file »


FAQ

Q: Can I connect multiple Google Accounts?

Yes, you can connect as many accounts as you need. To do so, please use the Connect Google Account button.

Q: Will this integration work with a free Google Account?

Yes, under one condition only. After you choose a Google Account to go with this integration, make sure to check-mark the "See and download all your Google Drive files" option.

"See and download all your Google Drive files" box checkmarked

If you don't give access to your Google Drive, spreadsheets from it won't show up within your Google Sheets integration.

Q: How do I delete my Google Account from Woodpecker?

If you wish to disconnect your Google Account from Woodpecker just click on the trash icon next to your Google login.

Q: If I update my spreadsheet on Google Drive would it also be updated in Woodpecker?

No, Woodpecker will not follow changes made to your spreadsheet. If you wish to update it, you’ll need to import it once again.

Q: I just uploaded a new spreadsheet, but I don’t see it in Woodpecker.

Use a refresh button every time there is a new spreadsheet created on your Google Drive in order to get it integrated with Woodpecker.

Did this answer your question?