This example shows how to use AirCode to sync your shopify data to a shared google spreadsheet.

Before you started, make sure you have the following:

• A Google Cloud account
• A Shopify Partners account
• A development store

1. Create a project in your google cloud account, then open the project's console:

• Click the APIs & Services Card

2. Click the Credentials in APIs & Services Page

• Click the CREATE CREDENTIALS button and create a Service account.
• When the new credentials created, copy the email show in the service accounts.

3. Click the Edit button on the right side of the service account email.

• At Service Edit Page, switch to the KEYS tab and click ADD KEY.

• By default, use JSON key and click CREATE button.

• When the KEY is created, the browser will automatically download a JSON file.

• You should save the json file content, and use it later in the AirCode project.

4. Go to the Google Sheets Page and create a new spreadsheet.

• You can copy the header of the sheets from this template file.

5. Click the Share button of the spreadsheet you created.

• Add your service accounts email just created before.

These are all the steps for setting up Google API.

1. Go to the dashboard of your Shopify Partners account, create a new store, or use an existing one.

2. Go to the admin console of your store.

• Click the Settings > Apps and sales channels
• Then click the Develop apps button.

3. Setting up your shopify app:

• Switch to Configuration Tab, add access permission of read_orders, read_products and read_customers.

• Switch to API Crendentials Page

• Create and copy the Admin API access Token. NOTE that you can only view and copy the token once.
• Please keep your token safe; we will need it in the upcoming Aircode project.

1. Get a copy of the sample project:

• You can easily get a copy and launch your app on AirCode by clicking the button below.

2. Open the project and set two Environments:

• SHOPIFY_TOKEN: The shopify admin api access token you just created.
• SPREAD_SHEET_ID: The google spreadsheet ID.

3. Open the credentials.json file, now it's a empty json.

• Copy the content of the google cloud api credentials file you just download.

4. Create a schedule job that runs every miniute.

5. Click the Deploy button to deploy your project online.

🎉 Now you successfully get your shopify store data sync to the google spreadsheet you shared.