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.

  1. When this happens...
    formlessformless
    New Response

    Triggers when a new response is submitted.

    TriggerInstant
  2. automatically do this...
    LobLob
    Verify US Address

    Corrects, standardizes, and enriches (e.g. county, geolocation, deliverability) a US address. Please see our documentation for details.

    ActionWrite
  3. then do this!
    Google SheetsGoogle Sheets
    Create Spreadsheet Row

    Create a new row in a specific spreadsheet.

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • ConversationRequired

    Trigger
    Instant
    Try It
    • 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

    Action
    Write
    • Recipient

    • Primary LineRequired

    • Secondary Line

    • City

    • State

    • Postal Code

    • CountryRequired

    Action
    Write
    • Recipient

    • Primary LineRequired

    • Secondary Line

    • Urbanization

    • City

    • State

    • Zip Code

    Action
    Write
    • 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

    Action
    Write
    • 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

    Action
    Write
    • Single Line US AddressRequired

    Action
    Write
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Scheduled
    Try It
formless logo
formless logo

About formless

Formless, Typeform's pioneering AI solution that elevates data collection through engaging, natural conversations.
Learn moreHelp

Related categories

  • Forms & Surveys
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn moreHelp

Related categories

  • Google
  • Spreadsheets

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
lob logo
lob logo

About Lob

Lob makes it easy to seamlessly print and mail letters, postcards, photos, posters and more via a web API.
Learn moreHelp

Related categories

  • Printing