Google Sheets + thanks.io + LeadConnector Integrations
How to connect Google Sheets + thanks.io + LeadConnector
Zapier lets you send info between Google Sheets, thanks.io, and LeadConnector automatically—no code required.
Do even more with Google Sheets + thanks.io + LeadConnector
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, thanks.io, and LeadConnector. And don’t forget that you can add more apps and actions to create complex workflows.
Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
The column position (zero-based) to insert. If not set, append to the right by default.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
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
Create a duplicate of an existing spreadsheet.
Headers
These Headers are ignored if a "Spreadsheet to Copy" is selected.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
Use a search step before this to get the row to delete.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Google Sheets are located here https://developers.google.com/sheets/api/reference/rest
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Value of the Worksheet Title to match exactly. Search is case-sensitive.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Specify the column we should search for cells which match the Lookup Value.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet? In other words, pick the most recent match?
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Specify the column we should search for cells which match the Lookup Value.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet? In other words, pick the most recent match?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundMailing List (if not selected, trigger will apply to all recipients)
Mailing List to associate with the trigger. If no mailing list is selected, trigger will apply to recipients added to any mailing list.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Mailing List (if not selected, trigger will apply to all recipients)
Mailing List to associate with the action. If no mailing list is selected, trigger will apply to any of your recipients who scans a QR code.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Recipient First Name
Not used if Full Name is specified. If First Name, Last Name, and Full Name is not specified, your Default Recipient Name is used.
Recipient Last Name
Not used if Full Name is specified. If First Name, Last Name, and Full Name is not specified, your Default Recipient Name is used.
Recipient Full Name
Used to set the recipients full name. Takes priority over First Name and Last name fields. If First Name, Last Name, and Full Name is not specified, your Default Recipient Name is used.
Full Address
Full address of where to send the postcard (for example, 123 Main Street, Anytown, NY 10990). This field takes priority over the Street City, State / Province and Postal Code fields. Either a Full Address or Street field is required.
Street Address
Street address of the recipient (123 Main Street). Not used if Full Address field is specified. Either a Full Address or Street field is required.
Unit or Apt (Address Line 2)
Used to specify Apartment/Unit Number. Only valid if not specifying Full Address in Address field.
City
Only valid if not specifying Full Address in Address field.
Postal Code
Only valid if not specifying Full Address in Address field.
State / Province
Only valid if not specifying Full Address in Address field.
Country Code
Two letter Country Code of recipient to delete. Defaults to US if not specified.
Recipient Email
Email Address of the Recipient.
Recipient Phone
Phone Number of the Recipient.
Recipient Company Name
Company Name of the Recipient
Message
This is the handwritten text that is included on the inside of the card. If neither a message template or a message are included, your default message template is used.
Message Template
This is the message template used for the handwritten text included on the inside of the card. If neither a message template or a message are included, your default message template is used.
Message Handwriting Style
Override the default handwriting style used for the message.
Image Template
Image ID that will be used for front of the notecard. If neither an image URL or an image ID are included, your default image is used.
Custom Field #1
Custom Field #2
Image URL
Link to image that will be used for front of the notecard. If neither an image URL or an image ID are included, your default image is used.
Custom Background Image URL
URL to custom background image to use for inside the notecard. Must be 1650x2475px jpg or png.
Custom Return Name
Custom Name to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Street
Custom Street to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Unit or Apt
Custom Return Unit or Apt (Address Line 2) to use for return address. US addresses only.
Custom Return City
Custom City to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return State
Custom State to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Postal Code
Custom Postal Code to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Sub Account
ID of sub account to use. If not sub account is selected, main account is used by default.
Giftcard Amount in Cents
Giftcard Brand
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Radius Search AddressRequired
Search Full Address (Example: 7777 Main St, Yonkers, NY) to use for center of nearest neighbor search.
Radius Search Record CountRequired
Number of nearest neighbors to search for. Valid numbers are 1-10000
Record Types
Which type of records to search for. Defaults to 'All'
Include Condos
Include condos in search. Defaults to true.
Use Property Owner
Use Property Owners Address when searching for a commercial Record Type. Defaults to false.
Message
This is the handwritten text that is included on the letter.
Message Template
This is the message template used for the handwritten text included on the letter.
Message Handwriting Style
Override the default handwriting style used for the message.
Image URL
Link to image that will be used for letter.
Image Template
Image ID that will be used for letter.
Custom Field #1
Custom Field #2
Envelope
Envelope type to be used. Blank envelop is used by default.
Additional Pages URL
URL to additional pages that should be appended to letter.
Custom Return Name
Custom Name to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Street
Custom Street to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Unit or Apt
Custom Return Unit or Apt (Address Line 2) to use for return address. US addresses only.
Custom Return City
Custom City to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return State
Custom State to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Postal Code
Custom Postal Code to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Sub Account
ID of sub account to use. If not sub account is selected, main account is used by default.
Append Data
Append phone and email to each record for an additional fee. Defaults to false.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Radius Search AddressRequired
Search Full Address (Example: 7777 Main St, Yonkers, NY) to use for center of nearest neighbor search.
Radius Search Record CountRequired
Number of nearest neighbors to search for. Valid numbers are 1-10000
Record Types
Which type of records to search for. Defaults to 'All'
Include Condos
Include condos in search. Defaults to true.
Use Property Owner
Use Property Owners Address when searching for a commercial Record Type. Defaults to false.
Message
This is the handwritten text that is included on the inside of card. If neither a message template or a message are included, your default message template is used.
Message Template
This is the message template used for the handwritten text included on the inside of card. If neither a message template or a message are included, your default message template is used.
Message Handwriting Style
Override the default handwriting style used for the message.
Image Template
Image ID that will be used for front of the notecard. If neither an image URL or an image ID are included, your default image is used.
Image URL
Link to image that will be used for front of the notecard. If neither an image URL or an image ID are included, your default image is used.
Custom Field #1
Custom Field #2
Custom Return Name
Custom Name to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Street
Custom Street to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Unit or Apt
Custom Return Unit or Apt (Address Line 2) to use for return address. US addresses only.
Custom Return City
Custom City to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return State
Custom State to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Postal Code
Custom Postal Code to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Sub Account
ID of sub account to use. If not sub account is selected, main account is used by default.
Append Data
Append phone and email to each record for an additional fee. Defaults to false.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Radius Search AddressRequired
Search Full Address (Example: 7777 Main St, Yonkers, NY) to use for center of nearest neighbor search.
Radius Search Record CountRequired
Number of nearest neighbors to search for. Valid numbers are 1-10000
Record Types
Which type of records to search for. Defaults to 'All'
Include Condos
Include condos in search. Defaults to true.
Use Property Owner
Use Property Owners Address when searching for a commercial Record Type. Defaults to false
Message
This is the handwritten text that is included on the back of the card. If neither a message template or a message are included, your default message template is used.
Message Template
This is the message template used for the handwritten text included on the back of the card. If neither a message template or a message are included, your default message template is used.
Message Handwriting Style
Override the default handwriting style used for the message.
Image Template
Image ID that will be used for front of the postcard. If neither an image URL or an image ID are included, your default image is used.
Image URL
Link to image that will be used for front of the postcard. If neither an image URL or an image ID are included, your default image is used.
Custom Background Image
URL to custom background image to use. Must be 1875px by 1275px.
Custom Field #1
Custom Field #2
Postcard Size
Size of postcard. Defaults to 4x6 by default.
Custom Return Name
Custom Name to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Street
Custom Street to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Unit or Apt
Custom Return Unit or Apt (Address Line 2) to use for return address. US addresses only.
Custom Return City
Custom City to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return State
Custom State to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Postal Code
Custom Postal Code to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
QR Code URL
URL to Autogenerate QR Code. This will show on the back of the postcard.
Sub Account
ID of sub account to use. If not sub account is selected, main account is used by default.
Append Data
Append phone and email to each record for an additional fee. Defaults to false.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Radius Search AddressRequired
Search Full Address (Example: 7777 Main St, Yonkers, NY) to use for center of nearest neighbor search.
Radius Search Record CountRequired
Number of nearest neighbors to search for. Valid numbers are 1-10000
Record Types
Which type of records to search for. Defaults to 'All'
Include Condos
Include condos in search. Defaults to true.
Use Property Owner
Use Property Owners Address when searching for a commercial Record Type. Defaults to false.
Message
This is the handwritten text that is included on the letter.
Message Template
This is the message template used for the handwritten text included on the letter.
Message Handwriting Style
Override the default handwriting style used for the message.
Image URL
Link to image that will be used for letter.
Image Template
Image ID that will be used for letter.
Custom Field #1
Custom Field #2
Additional Pages URL
URL to additional page that should be appended to letter (maximum of one additional page).
Custom Return Name
Custom Name to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Street
Custom Street to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Unit or Apt
Custom Return Unit or Apt (Address Line 2) to use for return address. US addresses only.
Custom Return City
Custom City to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return State
Custom State to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Postal Code
Custom Postal Code to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Sub Account
ID of sub account to use. If not sub account is selected, main account is used by default.
Append Data
Append phone and email to each record for an additional fee. Defaults to false.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.In PipelineRequired
Moved to Stage
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.First Name
Last Name
Full Name
Phone Number
Email
Address
City
State
Postal Code
Tags (comma delimited string for multiple tags)
Source
Mark as LeadRequired
Notes
Select PipelineRequired
Select StageRequired
Assign to User
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Phone Number
Email
First Name
Last Name
Full Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
No Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy To
Which spreadsheet should the worksheet be copied to? If left blank, it will be copied to the spreadsheet containing the original worksheet.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
Background Color
Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
Text Color
Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
Text Bold
True if the text is bold.
Text Italic
True if the text is italicized.
Text Strikethrough
True if the text is strikethrough.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Let us know which column you want to search by with the value below. We will grab the latest matching row and give you all of its values.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet?
Row Count
Number of rows to return. Max is 500.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
ColumnsRequired
Let us know which columns to return. e.g. A:Z
Row CountRequired
Number of rows to return. Max is 500.
First Row
Number of the first row to return (1 is the header)
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Value of the Worksheet Title to match exactly. Search is case-sensitive.
Headers
Overwrite?
If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundOrder IDRequired
ID of order to return results for.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planMailing List (if not selected, trigger will apply to all recipients)
Mailing List to associate with the action. If no mailing list is selected, trigger will apply to recipients added to any mailing list.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Mailing ListRequired
Recipient Full Name
Used to set the recipient's full name. If this is not specified the First Name field must be specified.
Recipient First Name
Required if Full Name is not specified. Not used if Full Name is specified.
Recipient Last Name
Not used if Full Name is specified.
Recipient Company
Used to set the recipient's company.
Street or Complete AddressRequired
Can either contain the full address of where to send the postcard (for example, 123 Main Street, Anytown, NY 10990) or just the street (123 Main Street). If only the street is given, then the City, State / Province and Postal Code fields must be specified.
Address Line 2
Used to specify Apartment/Unit Number. Only valid if not specifying Full Address in Address field.
City
Only valid if not specifying Full Address in Address field.
State / Province
Only valid if not specifying Full Address in Address field.
Postal Code
Only valid if not specifying Full Address in Address field.
Country Code
Two letter Country Code of recipient to delete. Defaults to US if not specified.
Birthday
Input format is flexible. Some formats that work are MM/DD/YYYY or YYYY-MM-DD.
Email
Email Address of the Recipient.
Phone
Phone number of the Recipient.
Custom Field #1
Custom Field #2
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Recipient First Name
Not used if Full Name is specified. If First Name, Last Name, and Full Name is not specified, your Default Recipient Name is used.
Recipient Last Name
Not used if Full Name is specified. If First Name, Last Name, and Full Name is not specified, your Default Recipient Name is used.
Recipient Full Name
Used to set the recipients full name. Takes priority over First Name and Last name fields. If First Name, Last Name, and Full Name is not specified, your Default Recipient Name is used.
Full Address
Full address of where to send the postcard (for example, 123 Main Street, Anytown, NY 10990). This field takes priority over the Street City, State / Province and Postal Code fields. Either a Full Address or Street field is required.
Street Address
Street address of the recipient (123 Main Street). Not used if Full Address field is specified. Either a Full Address or Street field is required.
Unit or Apt (Address Line 2)
Used to specify Apartment/Unit Number. Only valid if not specifying Full Address in Address field.
City
Only valid if not specifying Full Address in Address field.
Postal Code
Only valid if not specifying Full Address in Address field.
State / Province
Only valid if not specifying Full Address in Address field.
Country Code
Two letter Country Code of recipient to delete. Defaults to US if not specified.
Recipient Email
Email Address of the Recipient.
Recipient Phone
Phone Number of the Recipient.
Recipient Company Name
Company Name of the Recipient
Message
This is the handwritten text that is included on the letter.
Message Template
This is the message template used for the handwritten text included on the letter.
Message Handwriting Style
Override the default handwriting style used for the message.
Image URL
Link to image that will be used for letter.
Image Template
Image ID that will be used for letter.
Custom Field #1
Custom Field #2
Additional Pages URL
URL to additional pages that should be appended to letter.
Custom Return Name
Custom Name to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Street
Custom Street to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Unit or Apt
Custom Return Unit or Apt (Address Line 2) to use for return address. US addresses only.
Custom Return City
Custom City to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return State
Custom State to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Postal Code
Custom Postal Code to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
QR Code URL
URL to Autogenerate QR Code. This will show on the back of the postcard.
Sub Account
ID of sub account to use. If not sub account is selected, main account is used by default.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Recipient First Name
Not used if Full Name is specified. If First Name, Last Name, and Full Name is not specified, your Default Recipient Name is used.
Recipient Last Name
Not used if Full Name is specified. If First Name, Last Name, and Full Name is not specified, your Default Recipient Name is used.
Recipient Full Name
Used to set the recipients full name. Takes priority over First Name and Last name fields. If First Name, Last Name, and Full Name is not specified, your Default Recipient Name is used.
Full Address
Full address of where to send the postcard (for example, 123 Main Street, Anytown, NY 10990). This field takes priority over the Street City, State / Province and Postal Code fields. Either a Full Address or Street field is required.
Street Address
Street address of the recipient (123 Main Street). Not used if Full Address field is specified. Either a Full Address or Street field is required.
Unit or Apt (Address Line 2)
Used to specify Apartment/Unit Number. Only valid if not specifying Full Address in Address field.
City
Only valid if not specifying Full Address in Address field.
Postal Code
Only valid if not specifying Full Address in Address field.
State / Province
Only valid if not specifying Full Address in Address field.
Country Code
Two letter Country Code of recipient to delete. Defaults to US if not specified.
Recipient Email
Email Address of the Recipient.
Recipient Phone
Phone Number of the Recipient.
Recipient Company Name
Company Name of the Recipient
Message
This is the handwritten text that is included on the inside of the card. If neither a message template or a message are included, your default message template is used.
Message Template
This is the message template used for the handwritten text included on the inside of the card. If neither a message template or a message are included, your default message template is used.
Message Handwriting Style
Override the default handwriting style used for the message.
Image Template
Image ID that will be used for front of the notecard. If neither an image URL or an image ID are included, your default image is used.
Custom Field #1
Custom Field #2
Image URL
Link to image that will be used for front of the notecard. If neither an image URL or an image ID are included, your default image is used.
Custom Background Image URL
URL to custom background image to use for inside the notecard. Must be 1650x2475px jpg or png.
Custom Return Name
Custom Name to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Street
Custom Street to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Unit or Apt
Custom Return Unit or Apt (Address Line 2) to use for return address. US addresses only.
Custom Return City
Custom City to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return State
Custom State to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Postal Code
Custom Postal Code to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
QR Code URL
URL to Autogenerate QR Code. This will show on the back of the postcard.
Sub Account
ID of sub account to use. If not sub account is selected, main account is used by default.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Recipient First Name
Not used if Full Name is specified. If First Name, Last Name, and Full Name is not specified, your Default Recipient Name is used.
Recipient Last Name
Not used if Full Name is specified. If First Name, Last Name, and Full Name is not specified, your Default Recipient Name is used.
Recipient Full Name
Used to set the recipients full name. Takes priority over First Name and Last name fields. If First Name, Last Name, and Full Name is not specified, your Default Recipient Name is used.
Full Address
Full address of where to send the postcard (for example, 123 Main Street, Anytown, NY 10990). This field takes priority over the Street City, State / Province and Postal Code fields. Either a Full Address or Street field is required.
Street Address
Street address of the recipient (123 Main Street). Not used if Full Address field is specified. Either a Full Address or Street field is required.
Unit or Apt (Address Line 2)
Used to specify Apartment/Unit Number. Only valid if not specifying Full Address in Address field.
City
Only valid if not specifying Full Address in Address field.
Postal Code
Only valid if not specifying Full Address in Address field.
State / Province
Only valid if not specifying Full Address in Address field.
Country Code
Two letter Country Code of recipient to delete. Defaults to US if not specified.
Recipient Email
Email Address of the Recipient.
Recipient Phone
Phone Number of the Recipient.
Recipient Company Name
Company Name of the Recipient
Message
This is the handwritten text that is included on the back of the card. If neither a message template or a message are included, your default message template is used.
Message Template
This is the message template used for the handwritten text included on the back of the card. If neither a message template or a message are included, your default message template is used.
Message Handwriting Style
Override the default handwriting style used for the message.
Image Template
Image ID that will be used for front of the postcard. If neither an image URL or an image ID are included, your default image is used.
Image URL
Link to image that will be used for front of the postcard. If neither an image URL or an image ID are included, your default image is used.
Custom Background Image URL
URL to custom background image to use. Must be 1875px by 1275px.
Custom Field #1
Custom Field #2
Postcard Size
Size of postcard. Defaults to 4x6 by default.
Custom Return Name
Custom Name to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Street
Custom Street to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Unit or Apt
Custom Return Unit or Apt (Address Line 2) to use for return address. US addresses only.
Custom Return City
Custom City to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return State
Custom State to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Postal Code
Custom Postal Code to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
QR Code URL
URL to Autogenerate QR Code. This will show on the back of the postcard.
Sub Account
ID of sub account to use. If not sub account is selected, main account is used by default.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Recipient First Name
Not used if Full Name is specified. If First Name, Last Name, and Full Name is not specified, your Default Recipient Name is used.
Recipient Last Name
Not used if Full Name is specified. If First Name, Last Name, and Full Name is not specified, your Default Recipient Name is used.
Recipient Full Name
Used to set the recipients full name. Takes priority over First Name and Last name fields. If First Name, Last Name, and Full Name is not specified, your Default Recipient Name is used.
Full Address
Full address of where to send the postcard (for example, 123 Main Street, Anytown, NY 10990). This field takes priority over the Street City, State / Province and Postal Code fields. Either a Full Address or Street field is required.
Street Address
Street address of the recipient (123 Main Street). Not used if Full Address field is specified. Either a Full Address or Street field is required.
Unit or Apt (Address Line 2)
Used to specify Apartment/Unit Number. Only valid if not specifying Full Address in Address field.
City
Only valid if not specifying Full Address in Address field.
Postal Code
Only valid if not specifying Full Address in Address field.
State / Province
Only valid if not specifying Full Address in Address field.
Country Code
Two letter Country Code of recipient to delete. Defaults to US if not specified.
Recipient Email
Email Address of the Recipient.
Recipient Phone
Phone Number of the Recipient.
Recipient Company Name
Company Name of the Recipient
Message
This is the handwritten text that is included on the letter.
Message Template
This is the message template used for the handwritten text included on the windowless letter.
Message Handwriting Style
Override the default handwriting style used for the message.
Image URL
Link to image that will be used for letter.
Image Template
Image ID that will be used for letter.
Custom Field #1
Custom Field #2
Additional Pages URL
URL to additional page that should be appended to letter (maximum of one additional page).
Custom Return Name
Custom Name to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Street
Custom Street to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return Unit or Apt
Custom Return Unit or Apt (Address Line 2) to use for return address. US addresses only.
Custom Return City
Custom City to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Return State
Custom State to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
Custom Postal Code
Custom Postal Code to use for return address. US addresses only. Name, Street, City, State, and Postal Code are all required for custom return address to be used.
QR Code URL
URL to Autogenerate QR Code. This will show on the back of the postcard.
Sub Account
ID of sub account to use. If not sub account is selected, main account is used by default.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Mailing ListRequired
Street AddressRequired
Street Address (123 Main Street) of recipient to delete.
State / Province
Address Line 2
Used to specify Apartment/Unit Number.
City
Postal CodeRequired
Country Code
Two letter Country Code of recipient to delete. Defaults to US if not specified.
Email
Delete Recipient with this email address
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First Name
Last Name
Full Name
Phone Number
Email
Address
City
State
Postal Code
Tags (comma delimited string for multiple tags)
Source
Mark as LeadRequired
Notes
Business Name
Country
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CampaignRequired
First Name
Last Name
Full Name
Phone Number
Email
Address
City
State
Postal Code
Tags (comma delimited string for multiple tags)
Source
Lead Source
Notes
Event Time (Must be in ISO 8601 format ie. 2019-02-08T13:35:00-08:00)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Assign to User
Task TitleRequired
Task DescriptionRequired
Due Date (Must be in ISO 8601 format ie. 2019-02-08T13:35:00-08:00)
First Name
Last Name
Contact Phone
Contact Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
Top companies trust Zapier to automate work and free up time
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.
How Google Sheets + thanks.io + LeadConnector Integrations Work
- Step 1: Authenticate Google Sheets, thanks.io, and LeadConnector.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
Related categories
Similar apps
Zoho Creator
App Builder, Zoho
Smartsheet
Spreadsheets
Quip
Documents
About thanks.io
Related categories
About LeadConnector
Related categories
Get started for free
You can't add more hours to the day. Zapier is the next best thing.
Other Google Sheets + thanks.io Integrations
Other Google Sheets + LeadConnector Integrations
- manychat
- jotform
- email-parser
- surveygizmo
- gravity-forms
- typeform
- sms
- calendly
- activecampaign
- acuity-scheduling
- twilio
- stripe
- google-contacts
- facebook-lead-ads-beta
- wufoo
- google-drive
- pandadoc
- webinarjam
- thrivecart
- mailchimp
- hubspot
- kartra
- keap-max-classic
- leadshook
- linkedin-lead-gen-forms
- coupontools
- instapage
- zoom
- scheduleonce
- unbounce
- wpforms
- mailgun
- facebook-custom-audiences
- kajabi
- kvcore
- easywebinar
- asana
- microsoft-outlook
- leadpages
- woocommerce
- cognito-forms
- outgrow
- videoask
- upviral
- pipedrive
- google-ads
- convertkit
- wodify
- facebook-conversions
- webflow
- trainerize
- eventbrite
- signrequest
- trello
- squarespace
- thinkific
- proof
- zillow
- wispform
- whatconverts
- vanillasoft
- shopify
- paypal
- mailparser
- lemlist
- google-lead-form-extension
- google-forms
- google-calendar
- excel
- clickup
- callrail
- boomtown
- leadpops
- donorbox
- aweber
- zoho-crm
- sugarcrm7
- involveme
- google-docs
- powerisa-speed
- docusign
- walletly
- salesforce
- landbot
- xzazu
- zotabox
- zoho-mail
- zoho-books
- zenler
- zendesk
- youcanbookme
- xperiencify
- wordpress
- woobox
- wix-automations
- wave
- viral-loops
- tribe
- thrive-themes
- stealthseminar
- sql-server
- spotio
- signwell
- showcase-idx
- setschedule
- setmore-appointment
- scoreapp
- salesmate
- recurly
- recruiterflow
- rd-station
- pushbullet
- proagentwebsites
- podio
- phoneburner
- pdffiller
- pdfco
- parseur
- pando
- optinmonster
- ontraport
- nifty-pm
- monday
- mojo
- mobilemonkey
- microsoft-teams
- memberpress
- mailshake
- mailmunch
- leadquizzes3
- leadgen
- keap
- justcall
- jobnimbus
- jobber
- influence
- google-chat
- getresponse
- formly
- formidable
- form-data
- first-promoterwith-trig
- facebook-offline-conversions
- facebook-messenger
- evenium
- dropfunnels
- demio
- datavalidation
- credit-repair-cloud
- code
- closeio
- clicksend
- callhippo-1
- bucketio-2
- bitly
- billsby
- basin
- basecamp3
- apivideo
- 97display
- 17hats
- zoho-forms
- zendesk-sell
- workiz
- wodboard
- webinargeek
- poptin
- meet-alfred
- funnel-pages-app
- formstack
- contact-reach
- chatfuel
- autoklose
- seamless-ai
- bonjoro
- mailerlite
- follow-up-boss
- emma
- powr-form-builder