How to Create a new WooCommerce Data source in Google Sheets

Step 1: Install and Launch Two Minute Reports

Install Two Minute Reports, if you have not done already.

Sign in to any Google Sheet and go to Add-ons -> Get add-ons.

Search for Two Minute Reports and select Install.

Review and accept the permissions necessary to run Two Minute Reports. Two Minute Reports will be installed for you with the e-mail you are sign in to Google Sheets.

Open Google Sheets and go to Extensions -> Two Minute Reports -> Launch.

Step 2: Connect WooCommerce to Google Sheets

You would get TMR’s side bar at the right side of the sheet. You would be on the Data Sources sheet by default. Click on Add+ to create your new WooCommerce Data Source.

In the TMR side bar, Click on Select your source type option to view all the Data sources. From that, Choose WooCommerce from the Data source drop down and name your Data Source.

You will now be redirected to the Configuration part of WooCommerce.

Step 3: Generate API key and API secret

To get started with this process, you will need to log in to your WooCommerce account and navigate to the “Settings” page. From there, click on the “Advanced” tab and then select the “REST API” option.

This will take you to the WooCommerce REST API settings page.

On this page, you’ll see a section labeled “Keys/Apps.” This is where you can create and manage API keys for your WooCommerce store. To create a new key, click the “Create API key ” button.

Here, you would first need to specify the description for the purpose of requesting the API key then followed by adding the user who is requesting the key and finally Specify the permissions for the key, which can be Read, Write or Read and write. Finally click on “Generate API key”.

Now, you would be able to view the API key and API secret for once.

Make sure to copy the API secret key and save it somewhere secure. You’ll need this key to authenticate your requests when using the WooCommerce API.

Now, use this in place of API key and API secret in our Two Minute Reports configuration section and add your store URL to create your new TMR’s WooCommerce Data Source.

Once you add the credentials, Click on Test and Save. If your credentials where rite and the configuration was successful, you would get a successfully authenticated message in the TMR sidebar. Click Yes, to save the configuration.

Now, you can check the Data Sources section to view your newly created Data Source.

Step 4: Getting WooCommerce data in Google Sheets

Click on the menu icon, to choose Data Queries section.

Now, Create a new Query by adding a new Query name and selecting the newly added Data Source.

Now, you can start adding your desired metrics and dimensions for the date ranges you need and click on Run Query

Step 5: (Optional) Schedule Automatic data Refresh and email

Once you have fetched data once, you might want to get new data from your database at periodic intervals. You can do this creating a new schedule under the “Schedule Reports” section. You can schedule updates hourly, daily, weekly or monthly based on your needs.

You could also create a report and ask Two Minute Reports to email that report with updated data automatically. Under the email section enter the email Id of the recipients and save your new schedule.

When the time comes, Two Minute Reports will automatically fetch new data from your queries, and email your report to the said recipients. You have freed a lot of your time from mundane reporting tasks.

There are other features with Two Minute Report’s schedule refresh or data refresh feature. You may read our guide How to Refresh Data Automatically in Google Sheets.

I hope this article helped you successfully create a new Data source, Query Config and a WooCommerce report from Scratch.

Was this helpful?