Export your Google Shopping Feed to Google Sheets
After you have created your Google Shopping feed you may be helpful to view, filter and analyze further by exporting the data to Google Sheets. This can be helpful in debugging data issues between Shopify and Google.
There are two methods to export your data. Choose the 'Export All Data' option to download all available data, or choose the 'Export Filtered Data' option to filter a smaller set of data.
Export all Data
From the app dashboard view, click the History navigation menu
- Click the Exports tab
- Clicking the One-time exports sub-tab is the best way to find a shorter list of historical exports. You can also use the All tab to browse all exports
- Find and select the Google Shopping Feed export, from the row of items and it will redirect to the 'Google Feed' view
- Click the Download button to save the export to your local file
The Google Shopping feed file will download as a .txt text file that can be easily uploaded to any spreadsheet editor.
Export Filtered Data
From the app dashboard, prep and filter your set of products for export:
- Click the Export button once your products are filtered
- From the Export view, specify the 'Google Shopping Feed' format
- Click the Generate spreadsheet button
- Click the 'download' button to generate the .txt file
The .txt file should save automatically to your downloads folder.
Import to Google Sheets
From the Google Sheets view:
- Click the File → Import menu on the toolbar
- Select the Upload tab from the next screen and then the Browse button to find your file
- 'Create a new spreadsheet' or 'Insert the spreadsheet' are most commonly used, but you have other options as well:
- Click the Import data button to start processing
Your .txt file should now be formatted in the appropriate spreadsheet layout:
Now that your data is in Google Sheets you can easily filter for the products you want to examine.
✅ Tips and Troubleshooting
- Google Shopping files download as a .txt text file that can be easily uploaded to any spreadsheet editor.
- Reference this complete list of Google Shopping Fields that we gather data from
(07.183)