Google Sheets + PostGrid Print & Mail
Create Google Sheets rows for new letters in PostGrid Print & Mail
Once a new letter has been created in the PostGrid dashboard, a row with the letter information will be added to your specified Google Sheets spreadsheet.
Once a new letter has been created in the PostGrid dashboard, a row with the letter information will be added to your specified Google Sheets spreadsheet.
- When this happens...New Letter
Triggers when a new letter is created.
- automatically do this!Create Spreadsheet Row
Create a new row in a specific spreadsheet.
- Free forever for core features
- 14 day trial for premium features & apps
New Cheque
Triggers when a new cheque is created.
Try ItNew Postcard
Triggers when a new postcard is created.
Try ItDescription
First Name
Last Name
Company Name
Job Title
Email
Phone Number
Address Line 1Required
Address Line 2
City
Province or State
Postal or ZIP Code
Country CodeRequired
Recipient First Name
Recipient Last Name
Recipient Company Name
Recipient AddressRequired
Recipient Address 2
Recipient City
Recipient Province or State
Recipient Postal or ZIP Code
Recipient CountryRequired
Sender First Name
Sender Last Name
Sender Company Name
Sender Address
Sender Address 2
Sender City
Sender Province or State
Sender Postal or ZIP Code
Sender Country
Description
SizeRequired
Front HTML
Back HTML
PDF URL
Mailing Class
Send Date
Metadata
New Letter
Triggers when a new letter is created.
Try ItRecipient First Name
Recipient Last Name
Recipient Company Name
Recipient AddressRequired
Recipient Address 2
Recipient City
Recipient Province or State
Recipient Postal or ZIP Code
Recipient CountryRequired
Sender First Name
Sender Last Name
Sender Company Name
Sender AddressRequired
Sender Address 2
Sender City
Sender Province or State
Sender Postal or ZIP Code
Sender CountryRequired
Description
Bank AccountRequired
Cheque Number
AmountRequired
Memo
Message
Letter PDF URL
Letter HTML
Letter Size
Currency Code
Mailing Class
Send Date
Recipient First Name
Recipient Last Name
Recipient Company Name
Recipient AddressRequired
Recipient Address 2
Recipient City
Recipient Province or State
Recipient Postal or ZIP Code
Recipient CountryRequired
Sender First Name
Sender Last Name
Sender Company Name
Sender AddressRequired
Sender Address 2
Sender City
Sender Province or State
Sender Postal or ZIP Code
Sender CountryRequired
HTML
PDF URL
Return Envelope
EnvelopeRequired
Address Placement
ColorRequired
Double sidedRequired
Letter Size
Extra Service
Mailing Class
Perforate First Page
Send Date
Description
Metadata
Drive
SpreadsheetRequired
WorksheetRequired
Try It
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
About PostGrid Print & Mail
PostGrid's Print & Mail REST API allows you to send personalized letters, checks, or postcards on demand and at scale.
