Cleanup invalid addresses from Google Sheets using Lob

About

Every time a new Google Sheets row is added, Make will automatically verify the address using Lob. If the address is undeliverable it will remove that row. This example uses (this sheet)[https://docs.google.com/spreadsheets/d/1I_0ORbuaKUyehO5qj7l3iWRNYELfAuG5lQzLfyuSw9A/edit#gid=0].

Apps Included

Google Sheets

Lob

Get this template

Categories

Verification Tools

Direct Mail Marketing

Spreadsheets

Get this template

Similar templates for inspiration

Looking to get more out of your apps? With Make, you can visually integrate any app into any workflow to save time and resources - no coding required. Try any of these templates in just a few clicks.

Save a Gmail email containing a specific phrase to Google Sheets as a new row

Use this template to save a Gmail message containing a specific phrase to your Google Sheets spreadsheet as a new row.

Try It ➔

Send a Gmail email from a new Google Sheets row

Use this template to send a Gmail message when a new row is added to your Google Sheets spreadsheet.

To work with the template's default settings, your Google Sheets spreadsheet should contain these columns: Email address, Subject of the email and Content of the email.

Try It ➔

Add leads from Facebook Lead Ads to a Google Sheets spreadsheet

Every time a new lead is collected from Facebook Lead Ads, Make will automatically add a new row with the lead's info to Google Sheets spreadsheet.

Try It ➔

Share data added to a Google Sheet as Slack messages

This automation grabs new rows of data from your Google Sheet and sends them as Slack messages.

Try It ➔

Get Telegram messages for new Google Sheets rows

Every time a new row is added to your Google Sheets spreadsheet, Make will automatically send a message in Telegram.

Try It ➔

Save Telegram messages to a Google Sheets spreadsheet

Every time a new message is posted to a specified Telegram chat/channel, Make will automatically add that message to your Google Sheets spreadsheet as a new row. The template uses this example spreadsheet.

Try It ➔

Save Gmail emails and attachments to Google Sheets and Google Drive

Use this template to save a Gmail message to your Google Sheets spreadsheet as a new row and its attachments to Google Drive.

Try It ➔

Save new Facebook Lead Ads leads into Google Sheets

When you get a new response to a Facebook Lead Ads form, it will be logged as a new row in Google Sheets.

Try It ➔

Send Lob postcards from Google Sheets

Every time a new Google Sheets row is added, Make will automatically send a postcard to the person in the sheet using Lob and update the row in the sheet.

Try It ➔

Create your own workflow

Create custom workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.

Add a Conditional Format Rule

Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.

Action

Add a Row

Appends a new row to the bottom of the table.

Action

Add a Sheet

Adds a new sheet.

Action

Clear Values from a Range

Clears a specified range of values from a spreadsheet.

Action

Clear a Cell

Cleares a specific cell.

Action

Clear a Row

Clears values from a specific row.

Action

Copy a Sheet

Copies a sheet to another spreadsheet.

Action

Create a Spreadsheet

Creates a new spreadsheet.

Action

Create a Spreadsheet from a Template

Creates a new spreadsheet from a template sheet.

Action

FAQ

How do I get started with Make?

What is a scenario?

What is a module?

What is mapping?

Cleanup invalid addresses from Google Sheets using Lob

About

Apps Included

Create your own workflow

Trusted by 500,000+ Makers