Automated Google Sheet from JotForm Submissions

I have over 400 customers who pick up products from 18 pick up locations each week. These customers sign in at the location via a QR code that is linked to a JotForm. I need a Google Sheet that pulls data from my JotForm submissions to show who has signed in and who has not. The sheet should automatically update weekly to reflect current data. It should also be capable of distinguishing between customer orders via the Order ID from my website's API.

Key Requirements:

- The sheet should incorporate specific fields from JotForm submissions: Customer name and contact info, Submission timestamp.

- Data should be organized by Pick Up Location.

- Knowledge of API and Google Sheets is essential.

- The ability to distinguish different customer orders using the Order ID.

- The ability to distinguish if that customer has skipped or canceled their order for that week

-The ability to add new customers to respective pick up locations based on new orders

- Include error handling to manage API call failures or data retrieval issues.

- Provide filtering options to sort and view data based on specific criteria such as date, customer name, or order status.

Ideal Skills:

- Proficiency in Google Sheets and JotForm

- Experience with APIs

- Data organization skills

- Attention to detail

The freelancer will have full access to the website's API for seamless integration. Canceled or skipped orders should be highlighted in a different color. Set up notifications as per the response "I don't need alerts." "No data visualization or charts" as a data visualization/chart in the Google Sheet. No data visualization or charts needed; include only raw data in the Google Sheet.

**I will only provide compensation and correspondence via the freelancer website**