Has anyone explored bringing in LSI data into Google Data Studio? I currently update a Google spreadsheet each week based on LSI, and I just used that spreadsheet to make a nice dashboard in Data Studio. It would be SO nice if I didn't have to update the Google spreadsheet manually.
LMK if you have any ideas on how to do this!
This is amazing never thought of a connector, not just to get my dev to build one :) Beyond my capability lol
Thanks, VarunGrazitti! Unfortunately, it's a bit beyond me (or, at least beyond the time I have available to figure this out) to build my own connector. If anyone builds one for the Bulk Data API, please let me know!
Cheers!
VarunGrazitti - thanks for the offer! I just now realized that Grazitti is an agency. I doubt we'll be able to spend any $ to get this done, but I'll let you know if that changes.
Cheers!
Here's some additional context for this request - I have created two Data Studio dashboards for our community:
(1) Weekly metrics. These all come from a spreadsheet that I update manually from LSI each week.
(2) Metrics for the big screen. These show up on a big monitor above my desk for all to see. The data with the orange boxes in the screenshot comes from manually-updated spreadsheets; the rest comes from Google Analytics.
It would be so nice if I didn't have to update spreadsheets manually!
Very cool dashboard. Thanks for sharing.
For everyone bought in to the Microsoft Office 365 ecosystem we already have a Power BI connector to Lithium. Now there would "just" need to be an equivalent connector for the Data Studio... 🤓
