Can I add a Google Trends graph to Google Data Studio?

Question

I would like to add a Google Trends chart for a specific search term to my Google Data Studio report, but Trends is not an option in the Data Source list. I wasn't able to find an option to embed JavaScript either. Is it possible to add a Trends chart to a report in Data Studio? Thanks!

Answer 1

I am posting this workaround as it seems no similar solution has been provided since.

You can actually do this, using a small workaround:

1. Create the graph you want to embed using Google Trends.

2. Click the "embed" icon in the upper right corner of the graph, and copy the JS-code (for either desktop or mobile device)

3. Create a simple empty HTML-file using notepad or similar text editor. (including , , as per common standard). Place it in an empty folder on your hard drive.

4. Paste the Google Trends-embed code into the section of your HTML-file.

5. Go to https://app.netlify.com/drop and upload the whole folder (including your .html-file). Copy the direct link provided by Netlify. (note: Any other form of public hosting should work fine, this is just my personal preference)

6. In Google Data Studio, click "URL embed" and paste your direct link.

7. Voila! (Note: As this is a direct graph link and not a data feed, it, unfortunately, won't let you filter or change settings. but if configured wisely before copying the embed code, should do the trick for any time range, year-on-year or similar needs.)

Hope this helps someone :)

Answer 2

You can use supermetrics.com that has a google trends (free) datasource and then import a common sheet into your dashboard, the only problem is that you wont be able to change the date range, meaning its only "one way"

Answer 3

Unfortunately, the Google Trends data connector has stopped working in Supermetrics. They use an unofficial Google API that has been faulty lately.

The connector was removed Dec 2018.