SendGrid Reports Add-in for Excel 2013, 2016, Excel Online

This Office Add-in is a timesaver for everyone who keeps customer contacts in Excel and uses SendGrid for transactional or marketing emails. The add-in enables you to pull all reports on suppressed (invalid, unsubscribed, bounce, etc.) addresses from SendGrid to Excel in seconds. Use this data to clean up and update your contact lists, and eventually improve email delivery rates. This Office Add-in is available in Microsoft Office Store. You can import the following reports:

  • Bounces
  • Blocks
  • Spam Reports
  • Invalid Emails
  • Unsubscribes

How to use the SendGrid Reports Add-in:

1. Activate the Add-in:

  • Open your spreadsheet > Insert tab > My Add-ins, or My Apps > Store > Find and select the SendGrid Report Add-in > The menu will appear on the right panel of your spreadsheet. Drag and resize the panel as you wish.
  • Step 1. Log in to your SendGrid account. This information is used to make requests to SendGrid API.

sendgrid app_activate

2. Follow the steps on the add-in’s menu:

  • Step 2. Select the reports you want to load: bounces, spam, invalid, etc. If you want the reports as separate tables, select and load reports one by one. Otherwise, select all reports and all suspended contacts will be loaded as a single table.
  • Step 3. Select the columns you need in your report: email, date and time, data, type.
  • Select any empty cell in the spreadsheet to mark the starting cell of the report. Then click ‘Load Data’ and the report table is generated in seconds.

XLTools_SendGrid_App_2

XLTools_SendGrid_App_3

Done! The reports on suspended emails are loaded from your SendGrid account. Now you can remove these contacts from your marketing communication list. Get a free trial from the Office Store and discover the advantages of the add-in!

 

Any questions or suggestions? Contact us or leave your comment below.

One Response to SendGrid Reports Add-in for Excel 2013, 2016, Excel Online

  1. ray says:

    Maybe I’m not understanding the purpose of the app, but am I able to use this to email a report from excel?

    I registered with SendGrid and successfully installed this app in Excel, but I don’t see how to send this as an email from within the application.

Leave a Reply

Your email address will not be published. Required fields are marked *