IN THIS ARTICLE
Head over to our blog to learn How to Make Prospecting More Productive with Google Sheets? »
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.
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?
Log in to your Woodpecker account.
Go to Settings → Marketplace → Integrations.
Click on the icon with the Google Sheets logo:
4. Connect with your Google Account:
5. Allow Woodpecker to access your Google Account:
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.
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.
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 »
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.
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.