Project Overview: We run a Shopify-based doughnut bakery that ships nationwide in the UK. Currently, our team manually downloads outstanding orders as a CSV from Shopify and inputs them into Google Sheets to track production requirements. We want to automate this process using Airtable + Shopify, ensuring: ✅ Orders sync automatically from Shopify to Airtable. ✅ Doughnut flavours and quantities auto-organize into a production schedule. ✅ Ingredient calculations auto-update based on total doughnuts needed. ✅ Bakery staff can access real-time, shareable order data and use this data as a production schedule.
We’re looking for an Airtable + Shopify automation expert to set up this workflow.
Key Responsibilities: Connect Shopify to Airtable using Make (Integromat) or Zapier. Set up an Airtable base to track orders, doughnut flavours, and production totals. Automate order imports into Airtable, eliminating manual CSV downloads. Create formulas in Airtable to calculate the total ring/filled doughnuts per production day. Develop ingredient-tracking formulas based on doughnut quantities. Optimize Airtable views for easy access by bakery staff. Test the system to ensure smooth automation and accuracy. Provide basic training/documentation for our team to manage the system.
Requirements: ✔ Proven experience with Airtable & Shopify automation. ✔ Expertise in Make (Integromat) or Zapier for integrations. ✔ Strong skills in Airtable formulas, filters, and automations. ✔ Experience setting up inventory tracking and production workflows (preferred). ✔ Ability to create a user-friendly, scalable system for bakery operations. ✔ Excellent communication and ability to document the setup.
Deliverables: ✅ Fully automated Shopify → Airtable integration. ✅ Working Airtable base with order tracking, production planning, and ingredient calculations. ✅ Custom views for bakery staff to easily access relevant data. ✅ Step-by-step guide (or video tutorial) on how to use and maintain the system.
How to Apply: Please share examples of similar Airtable + Shopify projects you've completed. Let us know how you would approach this project and your estimated timeline. Include your rate and any relevant experience. Looking forward to working with an expert who can streamline our operations!
Below is an example of the google sheets document we are working with showing our baked doughnut schedule and fried doughnut schedules
Realistic Outdoor Sculptures Category: 3D Art, 3D Graphic Design, 3D Illustration, 3D Rendering, Art Installation, Graphic Design, Interior Design, Mural Painting, Sculpture, Visual Arts Budget: $750 - $1500 USD
19-Dec-2025 17:03 GMT
Cross-Platform Flutter App Development Category: Android, API Integration, Dart, Flutter, HTML5, IOS Development, IPhone, Mobile App Development Budget: $10 - $30 USD
19-Dec-2025 17:03 GMT
Modern Metal Handrail Shop Drawings Category: 2D Drafting, 3D Modelling, Architectural Engineering, AutoCAD, Building Architecture, Building Design, CAD / CAM, Construction Engineering Budget: £20 - £250 GBP
Edit Educational Story Video Category: Adobe Premiere Pro, After Effects, Audio Editing, DaVinci Resolve, Motion Graphics, Video Editing, Video Production, Video Services Budget: ₹600 - ₹1500 INR
19-Dec-2025 17:01 GMT
WordPress Elementor Website Management Category: Elementor, HTML, PHP, Web Development, Web Hosting, Web Design, Website Management, WordPress Budget: $15 - $25 USD
19-Dec-2025 17:00 GMT
Telegram Lecture Downloader Android Category: Android, Android Studio, API Integration, App Design, Java, Mobile App Development, Mobile Development, Software Architecture, Software Development, Telegram API Budget: ₹1500 - ₹12500 INR
Academic Rewrite: Research Paper (1200) words in 2 days Category: Academic Research, Academic Writing, Article Rewriting, Content Writing, Editing, Proofreading, Research, Research Writing, Technical Writing Budget: $10 - $30 USD
19-Dec-2025 16:56 GMT
Bangalore Housing Data Manipulation Category: Data Analysis, Data Extraction, Data Management, Data Science, Data Visualization, NumPy, Pandas, Python Budget: ₹400 - ₹750 INR
19-Dec-2025 16:56 GMT
New York Dental Clinic Leads Category: B2B Marketing, Data Collection, Data Entry, Data Scraping, Database Management, Excel, Lead Generation, Web Scraping, Web Search Budget: ₹12500 - ₹37500 INR
19-Dec-2025 16:56 GMT
Worldwide Amazon Book Launch Category: Amazon, Amazon Kindle, Book Cover Design, Book Marketing, Digital Marketing, Market Research, Publishing, SEO Budget: $250 - $750 USD
