Google Sheets + Facebook Lead Ads + Workbooks CRM Integrations
How to connect Google Sheets + Facebook Lead Ads + Workbooks CRM
Zapier lets you send info between Google Sheets and Facebook Lead Ads and Workbooks CRM automatically—no code required. With 7,000+ supported apps, the possibilities are endless.
Choose a Trigger
Start here
Start here
Choose an Action
Choose an Action
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Google Sheets + Facebook Lead Ads + Workbooks CRM
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Google Sheets, Facebook Lead Ads, and Workbooks CRM. And don’t forget that you can add more apps and actions to create complex workflows.
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Case
Triggers when a new case is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Person
Triggers when a new person is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Posted Credit Note
Triggers when a credit note is posted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Lookup nameRequired
Value
Value list
Default value
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Marketing CampaignRequired
StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Assigned ToRequired
Type
Status
Start Date
End Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer Order NameRequired
Assigned toRequired
Document CurrencyRequired
Customer Order DateRequired
StatusRequired
Tax point dateRequired
Product
Line Description
QuantityRequired
Unit price (document currency)Required
Additional Discount 1 %
Additional Discount 2 %
Delivery Country
Delivery County/State
Delivery date
Delivery Postcode/Zipcode
Delivery Street Address
Delivery Town or City
Discount given (document currency)
Discount given (home currency)
Display order
Document currency
End Date
Event
External Reference
Gross (document currency)
Gross (home currency)
Home currency
Location
Net (document currency)
Net (home currency)
Parent Line Item
Price Discount %
Pricing scheme
Sales tax (document currency)
Sales tax (home currency)
Sales tax code
Sales tax ruleset
Start Date
Status
Supply scheme
Tax adjustment (document currency)
Tax adjustment (home currency)
Total cost (document currency)
Total cost (home currency)
Unit cost (document currency)
Unit cost (home currency)
Unit price (home currency)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Title
Person NameRequired
Assigned ToRequired
Job Title
Job Role
Employer
First Name
Middle Name
Last Name
Salutation
Email
Telephone
Mobile
Industry
Street Address
Town or City
County/State
Postcode/Zipcode
Country
Preferred Language
Special Requirements
Source
Campaign
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SubjectRequired
Due Date
Completed Date
Assigned ToRequired
TypeRequired
StatusRequired
PriorityRequired
Primary Contact ID
Primary Contact Type
Description
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Lock VersionRequired
Customer Order Name
Assigned to
Document Currency
Customer Order Date
Status
Tax point date
Accounting period ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Lock VersionRequired
Title
Person Name
Assigned To
Job Title
Job Role
Employer
First Name
Middle Name
Last Name
Salutation
Email
Telephone
Mobile
Industry
Street Address
Town or City
County/State
Postcode/Zipcode
Country
Preferred Language
Special Requirements
Source
Campaign
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Campaign Name
Object Reference
External Reference
ActionThis is an event a Zap performs.SearchFind existing data in your appStatusRequired
Marketing CampaignRequired
External Reference
ActionThis is an event a Zap performs.SearchFind existing data in your appOrganisation Name
Website
Object Reference
External Reference
ActionThis is an event a Zap performs.SearchFind existing data in your appFirst Name
Last Name
Email
Organisation Name
Object Reference
External Reference
ActionThis is an event a Zap performs.SearchFind existing data in your appMember's Name
Party or Lead Id
Party or Lead Type
External Reference
EmailRequired
Marketing CampaignRequired
Marketing CampaignRequired
Party or Lead IDRequired
Party or Lead TypeRequired
Member's NameRequired
Status
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCustomer Order Name
External Reference
Object Reference
Customer Order NameRequired
Assigned toRequired
Document CurrencyRequired
Customer Order DateRequired
StatusRequired
Tax point dateRequired
Accounting period ID
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFirst Name
Last Name
Email
Employer
Object Reference
External Reference
Title
Person NameRequired
Assigned ToRequired
Job Title
Job Role
Employer
First Name
Middle Name
Last Name
Salutation
Email
Telephone
Mobile
Industry
Street Address
Town or City
County/State
Postcode/Zipcode
Country
Preferred Language
Special Requirements
Source
Campaign
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundPageRequired
Form
FBLA Copy
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Organisation
Triggers when a new organisation is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Sales Lead
Triggers when a new sales lead is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Posted Invoice
Triggers when an invoice is complete and its status posted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Marketing CampaignRequired
Party or Lead IDRequired
Party or Lead TypeRequired
Member's NameRequired
Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SummaryRequired
Assigned ToRequired
StatusRequired
Description
Contact
Contact Email
Contact Telephone
Priority
Product Category
Resolution Status
Resolution Description
Source
Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer Order NameRequired
Assigned toRequired
Document CurrencyRequired
Customer Order DateRequired
StatusRequired
Tax point dateRequired
Accounting period ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Organisation NameRequired
Assigned ToRequired
Category
Industry
Website
Telephone
Fax
Street Address
Town or City
County/State
Postcode/Zipcode
Country
Campaign
Source
VAT Number
Number of Employees
Preferred Language
Special Requirements
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Title
Lead Person's NameRequired
Assigned ToRequired
Job Title
Job Role
First Name
Middle Name
Last Name
Salutation
Email
Telephone
Mobile
Organisation
Organisation Category
Industry
Website
Street Address
Town or City
County/State
Postcode/Zipcode
Country
Rating
Source
Status
Campaign
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Lock VersionRequired
Member's NameRequired
Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Lock VersionRequired
Organisation Name
Assigned To
Category
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.IdRequired
Lock VersionRequired
Title
Lead Person's Name
Assigned To
Job Title
Job Role
First Name
Middle Name
Last Name
Salutation
Email
Telephone
Mobile
Organisation
Organisation Category
Industry
Website
Street Address
Town or City
County/State
Postcode/Zipcode
Country
Rating
Source
Status
Campaign
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Member's Name
Party or Lead Id
Party or Lead Type
External Reference
EmailRequired
Marketing CampaignRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer Order Name
External Reference
Object Reference
ActionThis is an event a Zap performs.SearchFind existing data in your appFirst Name
Last Name
Email
Employer
Object Reference
External Reference
ActionThis is an event a Zap performs.SearchFind existing data in your appCampaign Name
Object Reference
External Reference
NameRequired
Assigned ToRequired
Type
Status
Start Date
End Date
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundStatusRequired
Marketing CampaignRequired
External Reference
Marketing CampaignRequired
StatusRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundOrganisation Name
Website
Object Reference
External Reference
Organisation NameRequired
Assigned ToRequired
Category
Industry
Telephone
Fax
Street Address
Town or City
County/State
Postcode/Zipcode
Country
Campaign
Source
VAT Number
Number of Employees
Preferred Language
Special Requirements
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundFirst Name
Last Name
Email
Organisation Name
Object Reference
External Reference
Title
Lead Person's NameRequired
Assigned ToRequired
Job Title
Job Role
First Name
Middle Name
Last Name
Salutation
Email
Telephone
Mobile
Organisation
Organisation Category
Industry
Website
Street Address
Town or City
County/State
Postcode/Zipcode
Country
Rating
Source
Status
Campaign
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How Google Sheets + Facebook Lead Ads + Workbooks CRM Integrations Work
- Step 1: Authenticate Google Sheets, Facebook Lead Ads, and Workbooks CRM.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
