How to Import BigCommerce Pages into Google Sheets
Use the BigCommerce API to Import A List of Your Pages and Posts

I recently had the need to groom hundreds of pages in a client's BigCommerce account. These pages were created using Shogun Page Builder as a mixture of web pages and blog posts. 

If you need to manage the pages in BigCommerce you will quickly notice that they do not have an export option for pages, nor can you create an export template for pages.

However, we can quickly get any BigCommerce data (including orders, customers, and products) into Google Sheets using the BigCommerce API and Apps Script. This tutorial assumes you are familiar with Apps Script and have some programming experience. If you do not have any scripting experience, you can still follow along to get the pages without writing any code.

In this workbook you will find the complete Apps Script and functions, you can simply add your “Authorization Token” and “Store ID” to the top of the page to get the list of your pages.

Now let’s break down exactly what to do.

  1. First visit this workbook

  2. Copy the workbook by going to “File” > “Make A Copy”

  3. Go to your BigCommerce Store admin 

  4. Go to “Settings” and type “API” in the search

  5. Click on “API Accounts” (You must have the correct permissions or be administrator)

  6. In the top right click on “+Create API Account” (learn more)

  7. Choose token type “V2/V3 API token”

  8. Write a name for your API account ot recognize it easily

  9. Now click “read only” for “content”, “sites & routes”, and “information and settings”

  10. Save the account and a popup will appear with your credentials, it will also download a text file with the credentials. Keep this safe as you will need to create a new account if you loose it.

  11. Copy the “Authorization Token” to the “Token” (A2) cell on the top of the workbook.

  12. Copy your store id to the “Store ID” column (B2). W hen you change cells the data should update the spreadsheet with your pages. You can find your ID in the URL when you are logged into your BigCommerce admin. 

  13. Now you can “copy” and “paste values” into a new tab to work with your data.

  14. You can use the CONCAT() function with the “URL” column to create the clickable URL 

Breaking Down What’s Happening

We are using the ImportJSON script to call and parse the BigCommerce API response. Inside cell A2 you have an ImportJSON() function, which calls the bigcommerce API directly. Requests are made using the FetchAPI, remember that, although generous, request limits do apply to the FetchAPI.

The header “X-Auth-Token” is used for authorization, so you do not want to create credentials that have any write or modify access to avoid hackers and mistakes.

The JSON array response is parsed and each object is listed on a separate line. The (“/data” ,””) arguments to the function set the entry point and what to replace it with for the response. In this case all BigCommerce APIs return a “data” object with an array of objects as values. 

This same process will work for any API endpoint in BigCommerce. If you need to use the script for other APIs, simply modify the “headers” in the ImportAdvancedJSON function to meet your needs.

How to Import BigCommerce Pages into Google Sheets
JD Berkowitz 18 January, 2023
Share this post
Sign in to leave a comment
How to Run Mautic CLI Commands on Google Bitnami Installation
Manage your mautic instance with CLI commands via SSH