Skip to main content

Step 4: Create Your First Data Sheet

This guide walks through setting importing Amazon Seller Central and Amazon Ads data directly into Google Sheets via a data sheet.

Updated over 3 weeks ago

Now that you’re signed in and your Amazon data is being imported, the final step in initial setup is to create a Data Sheet in Google Sheets. This is where Profit Hawk will actually populate your Amazon data within the spreadsheet.

Profit Hawk Data Sheets

What’s the Data Sheet? It’s essentially a worksheet (tab) in your Google Sheet that will contain all the raw data fetched from your connected Amazon accounts. Think of it as the central table of data that you’ll use for analysis. Profit Hawk will keep this sheet updated automatically with the latest figures (once your data import has completed).

Create a Data Sheet

To create a Data Sheet: In the Profit Hawk sidebar, look for an option to Create Data Sheet (or similar). Clicking this will add a new tab to your spreadsheet, likely called something like “Profit Hawk Data” or the name of your data source. This sheet will fill in with your sales, ads, and other metrics from Amazon. (If your initial data import is still in progress, the sheet may populate once data is ready.)

Once the Data Sheet is created and filled, you can use it to build reports and dashboards. Profit Hawk provides pre-built templates for common Amazon seller dashboards, and you can always create your own analyses using the data sheet as a source.

What Next?

👉 Where to go next: Now that you’ve got your data flowing into Google Sheets, check out our next help article to learn how to use Profit Hawk’s templates and dashboards for reporting: Profit Hawk Data Sources and Templates/Dashboards/Reports. That guide will show you how to make the most of your new data (including creating the Data Sheet if you haven’t already, and exploring template dashboards and reports).

Did this answer your question?