Microsoft Excel + Lob

Send letters in Lob whenever new rows are added in Microsoft Excel

Streamline your mailing process with this workflow. Whenever a new row is added in your Microsoft Excel, it prompts a letter to be sent via Lob. Perfect for businesses wishing to respond promptly to data changes, this seamless integration ensures your letters are dispatched in response to each new data input. Eliminate manual work and enhance your productivity by letting this automation manage your mailing activities.

When this happens...
New Row in Table
Triggers when a new row is added to a table in a spreadsheet.
TriggerPolling
automatically do this!
Send Letter
Creates a new letter in a double window envelope that will be mailed to the 'to' address, and from the 'from' address. Please see our documentation (www.lob.com/docs#letters) for details.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Column IndexRequired
- Apply To
- Header Preservation
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- RowRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Search or write
- 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

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- New NameRequired
Action
Write
- Api Docs Info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- No Match Copy
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or 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

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Learn more