Automation Developer – Make.com / AI Con

🧠 Project Overview (“Our Thoughts on the Process”)
Altitude Roofing is automating its content creation workflow to transform roofing-related news into ready-to-post social media material.
Each day, the system will:
Pull news articles from a Google News RSS feed using keywords like “asphalt shingles” and “asphalt roofing.”
Summarize articles automatically with GPT (OpenAI API).
Generate social media captions (Facebook, Instagram, LinkedIn, X) that follow our brand tone and use Canadian spelling and hashtags.
Generate a realistic AI image to accompany the post.
Store all results (article info, summaries, captions, image links, etc.) in a centralized Google Sheet called “Roofing_Content_Pipeline_Template” in Google Drive.
This sheet will later feed a secondary scenario that reviews and schedules posts via Zoho Social.The goal is to eliminate manual content sourcing, speed up post creation, and ensure consistent tone and brand quality across all channels.
🧩 Developer Responsibilities
Design, build, and document a complete scenario in Make.com following the blueprint provided.
Integrate with:
Google News RSS (via HTTP)
OpenAI (Chat + Image endpoints)
Google Sheets (for writing results)
Make Data Stores (for de-duplication and tracking)
Implement robust error handling (log failures in a “Failures” sheet).
Create environment variables/config support for easy adjustments (brand name, hashtags, limits).
Validate GPT outputs as JSON before inserting into Sheets.
Add simple dry-run mode toggle for testing (skips image generation).
Ensure time zones are set to America/Toronto.
Provide documentation or short loom/video showing how to maintain and adjust the scenario (adding new keywords, sheet IDs, etc.).
⚙️ Technical Requirements
Strong experience with Make.com (or Integromat) — scenario design, routers, and error handling.
Familiarity with OpenAI API, JSON parsing, and dynamic field mapping.
Experience connecting Google Sheets and Google Drive through Make.
Understanding of API authentication (OAuth for Google / API key for OpenAI).
Bonus: Experience with Zoho integrations (for future publishing automation).
📊 Deliverables
A fully functional Make scenario that runs daily, writing new summarized roofing articles to the Google Sheet.
Supporting documentation (short written SOP or Loom video).
Clean variable structure, including:
BRAND_NAME
LOCALE
HASHTAGS_BASE
GOOGLE_SHEET_ID
MAX_POSTS_PER_RUN
IMAGE_STYLE
DRY_RUN
Logs and test output confirming successful end-to-end run.
🧭 Expected Outcome
By completing this automation:
Altitude Roofing will have daily, brand-ready content ideas sourced from real news.
Every entry in the Google Sheet will contain:
News metadata
GPT summary
Social captions for each network
AI-generated image URL OR VIA OUR OWN IN HOUSE IMAGES 
use this data to auto-publish or queue posts through Zoho Social.

 ... Show more