Required stack
필요 기술
ZapierMake (formerly Integromat)Google SheetsTwilio WhatsApp APISendGridMailchimpAPI Integration (Facebook/Instagram Lead Ads, Google Ads)
Project brief
프로젝트 내용
I need a lightweight, end-to-end solution that pulls fresh buyer leads from social media, real-estate listing sites, and Google Ads, drops them straight into a Google Sheet (or similarly shareable spreadsheet), and then automatically nurtures every contact through scheduled WhatsApp and email sequences.
Scope of work
• Capture leads in real time from Facebook-Instagram Lead Ads, popular property portals, and Google Ads forms.
• Map all key fields—name, phone, email, property interest, ad source—into one master spreadsheet with no manual copy-pasting.
• Trigger an instant “thank-you” WhatsApp message plus a customizable email drip (day 1, day 3, day 7, etc.) once the row is created.
• Provide a simple dashboard or settings page where I can edit message templates, turn sequences on/off, and view basic performance metrics (open/click/reply rates).
• Keep the whole stack low maintenance: APIs or tools such as Zapier/Make, Twilio WhatsApp API, SendGrid/Mailchimp, and Google Sheets are all acceptable, as long as the final flow is reliable and easy for a non-technical user to tweak.
Acceptance criteria
1. A live demo showing a test lead flowing from each platform into the spreadsheet within seconds.
2. Automated WhatsApp and email messages arrive on the test device with the correct personalization tokens.
3. Clear, step-by-step documentation so I can replicate or extend the workflows later.
If you have already built similar automations for property businesses, even better—please mention the tech you used and any sample results you can share.
Scope of work
• Capture leads in real time from Facebook-Instagram Lead Ads, popular property portals, and Google Ads forms.
• Map all key fields—name, phone, email, property interest, ad source—into one master spreadsheet with no manual copy-pasting.
• Trigger an instant “thank-you” WhatsApp message plus a customizable email drip (day 1, day 3, day 7, etc.) once the row is created.
• Provide a simple dashboard or settings page where I can edit message templates, turn sequences on/off, and view basic performance metrics (open/click/reply rates).
• Keep the whole stack low maintenance: APIs or tools such as Zapier/Make, Twilio WhatsApp API, SendGrid/Mailchimp, and Google Sheets are all acceptable, as long as the final flow is reliable and easy for a non-technical user to tweak.
Acceptance criteria
1. A live demo showing a test lead flowing from each platform into the spreadsheet within seconds.
2. Automated WhatsApp and email messages arrive on the test device with the correct personalization tokens.
3. Clear, step-by-step documentation so I can replicate or extend the workflows later.
If you have already built similar automations for property businesses, even better—please mention the tech you used and any sample results you can share.