Airtable-Shopify Integration + GoDaddy Page -- 2

We are a raffle business in which customers order digital art in exchange for entries for a grand prize. For example, a person may purchase $20 worth of digital art in exchange for 20 entries for the grand prize. We may set a maximum limit of entries for each drawing/campaign. We would like to have shopify integrated with Airtable. The first request is to have two Airtable tables, 1 with unique customers with their total amount of orders and entries. Since a customer can purchase multiple times, the table should have a total amount of entries within a designated date/time range. The second table will be the "draw" table. In this table, we will have each individual table row designate as an unique entry for each customer, also randomized. Previously mentioned about the max entries, we would also like to randomize these unique rows. For example, if a campaign has 10,000 max entries, and a customer purchases $20 (20 entries), we would like the rows to be created to be random (1, 4, 39, 51, 70, 200, 251, 388, and so on). The idea is that we would output the second table to a public website on Godaddy Airo so customers can reference their entries. We would use a third party randomizer to pick a random entry from the website that has Table 2. We are requesting a resource that has experience with Airtable integration with Shopify and can output into a Godaddy html. The data should be updated in real time and allow administration to change the filters for easy viewing. If you’re comfortable with the Airtable API, Shopify’s admin API or approved third-party connectors and can set up reliable automations, you’re exactly who I need. Deliverables • A fully configured Airtable ⇆ Shopify integration, tested end-to-end • A live GoDaddy page that pulls from the same data source • Clear hand-off notes outlining how to add new fields or products and troubleshoot basic sync issues Once those three items are working smoothly, the project is complete. We will also require post go live support as well. Communication We expect working time to be in Eastern Standard Time zone. The freelancer should be available to have calls with us to discuss follow ups and questions. Do not message me asking to connect outside of freelancer. We will only be interested in proposals where you have a portfolio with past examples working with airtable, shopify, and godaddy. Please also message me what HTML stands for consideration to this project. If you have a question, re-read this project. We see a lot of questions asked and they're not reading the description.