Google Sheets + Woodpecker.co

Create or update Woodpecker.co prospects from new Google Sheets rows in team drive

With this workflow, as soon as a new row is added to your team's Google Sheets spreadsheet, the data gets transferred seamlessly to Woodpecker.co, where a new prospect is created or an existing one is updated. This efficient process saves you the time and effort of manual data entry, ensuring your prospect list in the Woodpecker.co app is always up-to-date with the latest information from your team spreadsheet. With this automation, you can focus on what truly matters - connecting with your prospects.

When this happens...
New Spreadsheet Row (Team Drive)
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
TriggerScheduled
automatically do this!
Create/Update Prospect in Campaign
Adds a new prospect or updates existing prospect's data in a campaign of choice.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write

- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write

- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search or write
Email Sent
Triggers when Woodpecker sends an email to prospect from campaign.
Trigger
Instant
Try It
Follow-Up After Autoreply
Triggers when you set a date for resuming follow-ups after you got an autoreply from a prospect.
Trigger
Instant
Try It
Prospect Autoreplied
Triggers when you get an autoresponder from a prospect, or when you manually mark a prospect as AUTOREPLIED.
Trigger
Instant
Try It
Prospect Bounced
Triggers when a prospect’s email address bounces your message and the prospect status gets changed to BOUNCED in Woodpecker.
Trigger
Instant
Try It
Prospect Invalid
Triggers when a prospect’s email address doesn't exist on an external server. This check happens when Woodpecker tries to send an email to this prospect. Status is changed to INVALID in Woodpecker.
Trigger
Instant
Try It
Prospect Nonresponsive
Triggers when a prospect's status is changed to NONRESPONSIVE
Trigger
Instant
Try It
Prospect Opt Out
Triggers when prospect unsubscribes from your emails or is marked as OPT-OUT manually.
Trigger
Instant
Try It
Prospect Saved
Triggers when a Woodpecker prospect is created or updated.
Trigger
Instant
Try It
Manual Task Created
Triggers when a manual task of any type is created.
Trigger
Instant
Try It
Manual Task Ignored
Triggers when a manual task is marked as ignored.
Trigger
Instant
Try It
- EmailRequired
- LinkedIn URL
- Prospect's Status
- Update Existing Record
- First Name
- Last Name
- Company
- Website
- Tags
- Title
- Phone
- Address
- City
- State
- Country
- Industry
- Snippet 1
- Snippet 2
- Snippet 3
- Snippet 4
- Snippet 5
- Snippet 6
- Snippet 7
- Snippet 8
- Snippet 9
- Snippet 10
- Snippet 11
- Snippet 12
- Snippet 13
- Snippet 14
- Snippet 15
Action
Write
- EmailRequired
Action
Write

- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy To
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Search or write
Campaign Completed
Triggers when a Woodpecker campaign status changes to COMPLETED.
Trigger
Instant
Try It
Email Opened
Triggers when a prospect opens your email.
Trigger
Instant
Try It
Link Clicked
Triggers when a prospect clicks on a link in your email.
Trigger
Instant
Try It
Prospect Blacklisted
Triggers when a prospect status is changed to BLACKLISTED manually or when prospect unsubscribes from Woodpecker.
Trigger
Instant
Try It
Prospect Interested
Triggers when you mark a prospect who replied as INTERESTED.
Trigger
Instant
Try It
Prospect Maybe Later
Triggers when you mark a prospect who replied as MAYBE LATER.
Trigger
Instant
Try It
Prospect Not Interested
Triggers when you mark a prospect who replied as NOT INTERESTED.
Trigger
Instant
Try It
Prospect Replied
Triggers when a prospect replies to your email or is manually marked as REPLIED in Woodpecker.
Trigger
Instant
Try It
Secondary Reply
Triggers when a secondary reply is found by Woodpecker.
Trigger
Instant
Try It
Manual Task Done
Triggers when a manual task is marked as done.
Trigger
Instant
Try It
- CampaignRequired
- LinkedIn URL
- EmailRequired
- Update Existing Record
- Force changes
- Prospect's Status
- Prospect's Interest Level
- First Name
- Last Name
- Company Name
- Website
- Tags
- Title
- Phone
- Address
- City
- State
- Country
- Industry
- Snippet 1
- Snippet 2
- Snippet 3
- Snippet 4
- Snippet 5
- Snippet 6
- Snippet 7
- Snippet 8
- Snippet 9
- Snippet 10
- Snippet 11
- Snippet 12
- Snippet 13
- Snippet 14
- Snippet 15
Action
Write
- Prospect IDRequired
Action
Write
- Email AddressRequired
Action
Search

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more Help

Related categories

Similar apps

Zapier Tables

Databases, Spreadsheets, Zapier

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

About Woodpecker.co

Woodpecker.co helps B2B companies directly contact prospective clients by automated sending of personalized sales emails and follow-ups. Send emails and follow-up sequences automatically from your mailbox and have all the replies detected. Grow your business within the Predictable Revenue methodology by Aaron Ross in outbound, and nurture your inbound leads more personally to build valuable B2B relations.

Learn more Help

Related categories

Drip Emails

PRODUCTS

CAPABILITIES

By team

Google Sheets + Woodpecker.co

Create or update Woodpecker.co prospects from new Google Sheets rows in team drive

New Spreadsheet Row (Team Drive)

Drive

WorksheetRequired

New Spreadsheet

Drive

New or Updated Spreadsheet Row

No Team Drive

SpreadsheetRequired

WorksheetRequired

Trigger Column

Create Spreadsheet Column

Drive

SpreadsheetRequired

WorksheetRequired

Column NameRequired

Index

Create Multiple Spreadsheet Rows

Drive

SpreadsheetRequired

WorksheetRequired

Create Spreadsheet

TitleRequired

Spreadsheet to Copy

Headers

Delete Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

RowRequired

Update Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

RowRequired

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Find Worksheet

Drive

SpreadsheetRequired

TitleRequired

Lookup Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

Supporting Lookup Column

Supporting Lookup Value

Bottom-Up

Find or Create Row

Drive

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

Supporting Lookup Column

Supporting Lookup Value

Bottom-Up

Email Sent

Follow-Up After Autoreply

Prospect Autoreplied

Prospect Bounced

Prospect Invalid

Prospect Nonresponsive

Prospect Opt Out

Prospect Saved

Manual Task Created

Manual Task Ignored

Create/Update Prospect