How to create a Connection in Google Sheets?



Connections enable seamless data retrieval from your data sources, ensuring consistency—let’s get started with creating one. Before you start, ensure the TMR add-on is installed in Google Sheets to make the Connection. Let me guide you through the step-by-step process of creating that Connection.

💡Terminologies used

Connector: A Connector facilitates connectivity to a specific data source. For example, a Facebook Ads Connector provides connectivity to a Facebook Ads account.

Connection: A Connection is a link between the data source and the Connector. For example, to get data from Google Ads, you must use the Google Ads Connector to create a Connection with your Google Ads account.

Step 1: Navigate to the menu dropdown in the TMR sidebar and click “Connections”. Next, click “Add” to create a new connection.

Step 2: The “Adding new connection” dialog box appears. Here, we will perform three key steps to establish a Connection in Google Sheets, which takes less than 2 minutes:

  • Selecting the Connector 
  • Authentication 
  • Mapping accounts with the respective Connector

You can choose your preferred Connector from the list of options. For example, select Facebook Ads. Next, authorize your Connection by specifying your login credentials. 

Refer to the screenshot below for easier understanding:

Step 3: After successful authentication, you will see a streamlined interface that displays the account name, ID, Connection name, status, and Speedboost, as shown below.

Step 4: You must enable the toggle for the ad accounts from which you want to run queries. Please note that the disabled accounts cannot fetch data or execute queries. This approach keeps your Google Sheets dashboard well-organized, as you select only the required ad accounts for data analysis and client reporting.

💡Terminologies used

Warm-up: The time when data is being fetched from the respective platform by Two Minute Reports.

Periodic sync: Appending fresh data to retrieve the latest insights quickly.

Step 5: By default, the warm-up stage will automatically begin for the enabled accounts (as shown in the above screenshot). 

For most Connectors, you can extract and run queries during the warm-up stage. However, for the Amazon Ads Connector and Shopify Connector, you’ll need to wait until the warm-up stage is complete, which may take approximately 2 to 24 hours. TMR will email you once the warm-up is finished, allowing you to start running queries.

Once you’ve enabled the associated accounts, you can hit “Refresh Connections” to ensure the connected accounts are reflected in the TMR sidebar.

Note: The following terminologies indicate the Speedboost milestones you need to know to track your progress.

Speedboost milestone status

In-progress:

The small green dot indicates that the warm-up is about to begin. Once the warm-up completes, the ✅ sign appears, signaling the start of the periodic sync.

Completed:

Both the warm-up and the periodic sync is completed.

Errored:

The red caution mark indicates an error occurred while performing warm-up or periodic sync.

And that’s it. You’ve created a new Connection on Google Sheets. This ease of creating and managing Connections in a well-structured interface sets the cornerstone for generating data-driven insights.

Now that you know how to create a Connection, you can start choosing relevant accounts and run queries to extract actionable insights. Check out “How to run a query in Google Sheets” to get started.

We hope you found this guide helpful. If you have any questions, please contact our support team via support@twominutereports.com.


Was this helpful?