Google Sheets + Typeform + Lob
Create Google Sheets rows for new Lob-verified Typeform entries
Use Lob's smart APIs to easily verify and standardize mailing addresses that you collect in your Typeform entries. 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 Typeform entries. Addresses are added to a Google Sheet once verified.
- When this happens...New Entry
Triggers when a form 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
FormRequired
Try ItForm To DuplicateRequired
Choose Workspace To Duplicate This Form In (Leave blank to duplicate in same workspace)
Title of Your Duplicate Form (leave blank for same title)
Api Docs Info
Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
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
title of your formRequired
Choose Workspace To Create This Form In, leave it blank for default workspace
Form To Update Question inRequired
Please provide list of choices
FormRequired
responses submitted since the specified date and time.
responses submitted until the specified date and time.
search for responses that include the specified string.
search for responses that are complete.
maximum number of responses to fetch (default: 25, max: 1000)
Description
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
