Build Simple Zapier Automation: Google Sheets → OpenAI → Update Row (No Looping)
UpworkGBNot specifiedexpertScore: 59
Google SheetsAutomationZapierAPI
Project Overview
I need a simple Zapier automation built that enriches business data in a Google Sheet using OpenAI.
When I enter:
• Business Name
• City
and set a “status” column to RUN, Zapier should:
1. Send the business name + city to OpenAI
2. Return structured JSON only
3. Populate specific columns in the same row
4. Change status to DONE
5. Not re-trigger or loop
This is a basic version. I do NOT need external APIs like Google Places. OpenAI enrichment is sufficient.
Scope of Work
Build one working Zap that includes:
1. Google Sheets trigger (New or Updated Row)
2. Filter step (only run when status = RUN)
3. OpenAI step that returns strict JSON
4. JSON parsing step (Code by Zapier or structured output)
5. Update the SAME row with mapped fields
6. Set status to DONE to prevent looping
Fields to populate:
• website
• phone
• email
• address
• postcode
• category
• short_description (max 150 characters)
• instagram
• facebook
• tiktok
• notes
Requirements
• Must not loop or repeatedly trigger itself
• Must not append extra characters or malformed JSON
• Must use clean structured output
• Must be tested with at least 5 sample businesses
• Must include short Loom walkthrough (5–10 mins max) explaining how it works
• Must include brief written handover instructions
Deliverables
• Fully functioning Zap
• Clean prompt inside OpenAI step
• JSON parsing implemented correctly
• Google Sheet mapped correctly
• Status control working (RUN → DONE)
• Loom walkthrough
• 7 days post-delivery support for minor fixes
Timeline
I want this completed within 48 hours of hire.
Budget
Fixed price preferred.
This is a small, straightforward build for someone experienced with Zapier + OpenAI.
To Apply
Please respond with:
1. Confirmation you have built Zapier + OpenAI automations before
2. How long this will take you
3. Fixed price
4. One short example of similar automation work
Please keep proposals concise. Overly complex approaches will not be considered.
Unlock AI Intelligence, score breakdowns, and real-time alerts
Upgrade to Pro — $29.99/moClient
Spent: $3,174.86Rating: 5.0Verified