formless + Google Sheets + Lob
Create Google Sheets rows for new Lob-verified formless responses
Use Lob's smart APIs to easily verify and standardize mailing addresses that you collect in your formless responses. Addresses are added to a Google Sheet once verified.
Use Lob's smart APIs to easily verify and standardize mailing addresses that you collect in your formless responses. Addresses are added to a Google Sheet once verified.
- When this happens...New Response
Triggers when a new response is submitted.
- automatically do this...Verify US Address
Corrects, standardizes, and enriches (e.g. county, geolocation, deliverability) a US address. Please see our documentation for details.
- then 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
ConversationRequired
Try ItDescription
Size
Front File for PostcardRequired
Back File for PostcardRequired
To Address Name
To Address Company
To Address Line 1Required
To Address Line 2
To Address City
To Address State
To Address Zip
To Address Country
From Address Name
From Address Company
From Address Line 1
From Address Line 2
From Address City
From Address State
From Address Zip
Mail Type
Send Date
Use TypeRequired
Idempotency Key
QR Code Position
QR Code Redirect URL
QR Code Width
QR Code Top
QR Code Right
QR Code Left
QR Code Bottom
QR Code Pages
QR Code Logo URL
QR Code Background Color
QR Code Foreground Color
Recipient
Primary LineRequired
Secondary Line
City
State
Postal Code
CountryRequired
Recipient
Primary LineRequired
Secondary Line
Urbanization
City
State
Zip Code
Description
FileRequired
ColorRequired
Address Placement
Double Sided
To Name
To Address Company
To Address Line 1Required
To Address Line 2
To Address City
To Address State
To Address Zip
To Address Country
From Address Name
From Address Company
From Address Line 1Required
From Address Line 2
From Address CityRequired
From Address StateRequired
From Address ZipRequired
Mail Type
Return Envelope
Custom Envelope
Perforated Page
Extra Service
Send Date
Use TypeRequired
Idempotency Key
QR Code Position
QR Code Redirect URL
QR Code Width
QR Code Top
QR Code Right
QR Code Left
QR Code Bottom
QR Code Pages
QR Code Logo URL
QR Code Background Color
QR Code Foreground Color
Description
Size
Inside File for Self-MailerRequired
Outside File for Self-MailerRequired
To Address Name
To Address Company
To Address Line 1Required
To Address Line 2
To Address CityRequired
To Address StateRequired
To Address ZipRequired
From Address Name
From Address Company
From Address Line 1
From Address Line 2
From Address City
From Address State
From Address Zip
Mail Type
Send Date
Use TypeRequired
Idempotency Key
QR Code Position
QR Code Redirect URL
QR Code Width
QR Code Top
QR Code Right
QR Code Left
QR Code Bottom
QR Code Pages
QR Code Logo URL
QR Code Background Color
QR Code Foreground Color
Single Line US AddressRequired
Drive
SpreadsheetRequired
WorksheetRequired
Try It
