search

sendgrid / opensource

SendGrid Open Source Dashboard
http://github.com/sendgrid
MIT License
34 stars 13 forks source link

Google Data Studio Connector #19

Open dfoster67 opened 4 years ago

dfoster67 commented 4 years ago

I've been using Google Data Studio for some other reporting/dashboard needs and wanted to incorporate my SendGrid stats data. I searched for an existing connector, but didn't find one. So, as an experiment I built one this weekend. Right now it just pulls the global stats and is pretty basic, but I would be glad to share it here if appropriate. It is just in App Studio now, as I'm not sure how to migrate it to Git, but will work on that next. Please reply if you are interested in it and I am glad to share.

beatyconsultancy commented 3 years ago

Hi Doug. I would be super grateful for a copy of your connector if you would be willing to share! Cheers brother.

dfoster67 commented 3 years ago

@beatyconsultancy I couldn't find an easy way to share it with you in Data Studio, so I put a copy out in GIt: https://github.com/dfoster67/SendGrid-Connector

It was designed to run in App Script, and based off one of Google's examples. It's been a while since I did much with it as I am now using PowerBI, where I was able to work out how to pull the data directly from the API. Take a look at the repo. Hopefully it helps.

beatyconsultancy commented 3 years ago

You sir, are a scholar and a gentleman. @dfoster67