Extract Shopify Orders on daily schedule into Google Sheets

We are seeking a skilled professional to assist me with extracting order information from our clients' Shopify stores into Google Sheets on a daily schedule.

The ideal candidate will have experience in accessing and extracting data from the Shopify API (such as through the order.json file or similar methods) and outputting it in Google Sheets. We anticipate that this task could be automated using a Google Apps Script or a similar solution, but we are open to other methods as long as they reliably achieve the desired results.

Responsibilities

- Extract order data from multiple Shopify stores on a daily basis.
- Utilise the Shopify API (order.json file or similar methods) to access the necessary order information.
- Automate the data extraction process, preferably using Google Apps Script or a similar tool, to update Google Sheets daily.
- Ensure that all required data columns are accurately transferred to Google Sheets. The columns needed are attached in the provided image.
- Troubleshoot any issues in the data extraction process and ensure accuracy and consistency of data.

Qualifications

- Experience working with the Shopify API, particularly with order.json or similar data access methods.
- Strong understanding of Google Sheets and experience in automating data extraction, preferably through Google Apps Script.
- Ability to work independently and troubleshoot any issues with data extraction or automation.
- Familiarity with data organisation, ensuring all required columns are consistently populated and formatted.

Price is placeholder. Immediate start. Please send your proposals