How to Import Google Trends Data into Google Sheets (2024)

‍

Keeping track of what's trending online is crucial for various endeavors, from market research and content creation to understanding consumer behavior. Google Trends allows you to explore search trends over time and across regions. But how do you seamlessly integrate this valuable information into your workflow, specifically Google Sheets?

‍

‍

‍

This guide dives into using Two Minute Reports, a fantastic add-on for Google Sheets, to import Google Trends data in 2024 effortlessly. Let's explore how to bridge these two platforms and unlock valuable insights for your projects.
‍

Steps to Import Google Trends Data with Two Minute Reports:
‍

• Google Account: You'll need a Google account to sign up for Google Sheets, Google Trends, and the Two Minute Reports add-on.
  ‍
• Two Minute Reports Account (Optional): While not mandatory, a free account on https://twominutereports.com/ allows you to save report templates and access additional features.
  ‍

Then, 

1. Install the Add-on: Open the Google Workspace Marketplace and search for "Two Minute Reports." Install it like any other add-on. 
   ‍

Or open up your Google Sheets, navigate to the toolbar, and click Extensions. Click Add-ons, Get Add-ons, search for Two Minute Reports, and select Install to add it to your Sheets. Allow all permissions for Two Minute Reports in your Google Sheets account.

2. Launch Two Minute Reports: Navigate to your Google Sheet and go to Extensions > Add-ons > Two Minute Reports > Launch.
   ‍
   
   
3. Connect to Google Trends: Within the sidebar, click the "Data Source" button under the SEO section and choose "Add" followed by "Google Trends." Follow the on-screen prompts to authorize Two Minute Reports with your Google account for accessing Google Trends data. Hit Save.
   ‍
   
   
4. Create a New Query: Locate the "Queries" section in the sidebar and click "Create new query" (or choose an existing template if available). Upon clicking Add, you will be prompted to name your Query and select a data source. Ensure "Google Trends" is selected as the data source.
   ‍
   
   
5. Define Your Google Trends Query: Here's where you specify what data you want to import:
   
   
   • Search Terms: Enter the keywords or topics you want to track trends for (separated by commas).
     ‍
   • Country: Narrow down the search by selecting a specific country or region (optional).
     ‍
   • Search Type: "Web Search" is the default and recommended option.
     ‍
   • Category: Refine your search further by selecting a relevant industry category (optional).
     ‍
   • Metrics: Choose the data you want to import from Google Trends, such as "Interest over time," "Related Queries," or "Related Topics."
     ‍
   • Dimensions: Segment the data further by selecting options like "By subregion" or "By device" (optional).
     ‍
   • Date: Set the desired date range for retrieving trend data.
     ‍
     ‍
6. Run the Query: Once you've configured your query, click the blue Run Query button. Two Minute Reports will fetch data from Google Trends and automatically import it directly into your Google Sheet.
   
   
7. Review and Customize (Optional): The imported data will appear in your sheet. You can then review, format, and analyze it as needed. Two Minute Reports provides some basic data manipulation options within the add-on.
   
   
8. Schedule Automatic Data Refresh (Optional): In the Two Minute Reports sidebar, click "Schedules" and choose "Create new schedule." Set how often you want the data to be automatically refreshed (e.g., daily, weekly) to ensure your Google Sheet reflects the latest trends.
   
   

Bonus Tip: Explore the "Templates" section within the "Queries" tab. Two Minute Reports offers pre-made templates for common Google Trends queries, saving you time on configuration.

Conclustion For Insights with Two Minute Reports

By following these steps, you can leverage Two Minute Reports to import Google Trends data into your Google Sheets efficiently. This powerful combination allows you to gain valuable insights into search trends, stay ahead of the curve, and make informed decisions. Remember, the free plan of Two Minute Reports has limitations on reports and refreshes. Consider upgrading for more intensive data analysis needs.

So, the next time you need to analyze trending topics, utilize Two Minute Reports to bridge the gap between Google Trends and your Google Sheets, empowering data-driven decision-making and success in your endeavors.