How to Load data from SendGrid to Google BigQuery

How to load data from SendGrid to BigQuery

Continuing with our view on the transactional email services, today we are going to see Sendgrid. SendGrid is a transactional email service. But what if I want to get more data-driven and gather all my transactional data from SendGrid to my BI or custom analytics stack or to my data warehouse like BigQuery? How can I analyse the data generated with SendGrid as part of your transactional email campaigns? This guide is going to provide you with a clear picture about how to load data from SendGrid to Google BigQuery.  We will use SendGrid’s API to access and extract e-mail related data and load it into Google BigQuery for further analysis.

Continue reading