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
AI-Powered Mobile Chat Application -- 2 Category: AI Chatbot Development, AI Development, AI Text To Speech, Android, Chatbot, IPhone, Mobile App Development, Objective C Budget: $3000 - $5000 USD
20-Dec-2025 23:03 GMT
Copy Reels Instagram Menarik - 19/12/2025 00:30 EST Category: Article Writing, Content Writing, Copywriting, Digital Marketing, Ghostwriting, Instagram Marketing, Social Media Management, Social Media Marketing Budget: $2 - $8 USD
20-Dec-2025 23:03 GMT
Salesforce Consulting Business Developer Category: B2B Marketing, Business Development, Consulting, CRM, Lead Generation, Market Research, Sales, Salesforce App Development, Salesforce.com, SAP Budget: $250 - $750 USD
20-Dec-2025 23:02 GMT
Transactional SQL Queries & Visuals Category: Data Analysis, Data Visualization, Database Design, Database Development, Database Programming, Microsoft Access, MySQL, SQL Budget: £10 - £20 GBP
20-Dec-2025 22:58 GMT
Edición Integral de Podcast Category: Audio Editing, Audio Production, Podcast Editing, Post Production, Sound Engineering, Video Editing, Video Production, Video Services Budget: €8 - €30 EUR
20-Dec-2025 22:57 GMT
Market Chiang Mai, Thailand Condos Category: Advertising, Content Marketing, Copywriting, Creative Design, Digital Marketing, Facebook Marketing, Instagram Marketing, Internet Marketing, Marketing, Social Media Marketing Budget: $15 - $25 USD
20-Dec-2025 22:53 GMT
Fresh Pan-India MBA Leads Category: CRM, Data Analysis, Data Collection, Data Entry, Email Marketing, Excel, Google Adwords, Internet Marketing, Lead Generation, Market Research Budget: ₹1500 - ₹12500 INR
Instagram DM Outreach to Prospects Category: Analytics, Content Creation, Content Strategy, Data Entry, Digital Marketing, Email Marketing, Google Sheets, Instagram Marketing, Social Media Management, Social Media Marketing Budget: $2 - $8 USD
20-Dec-2025 22:48 GMT
Upgrade-Safe Dolibarr Document Module Category: API Development, Database Design, Documentation, PHP, Project Management, Software Development, Technical Writing, Web Development Budget: $10 - $50 AUD
20-Dec-2025 22:48 GMT
English Articles into Spanish Category: Article Writing, Content Writing, Editing, English (US) Translator, Language Tutoring, Proofreading, Spanish Translator, Translation Budget: $8 - $15 CAD
20-Dec-2025 22:46 GMT
Modern Serif Text Logo Needed Category: Adobe Creative Suite, Adobe Illustrator, Graphic Design, Illustration, Logo Design, Photoshop, Typography, Vector Design Budget: $30 - $250 USD
