Google Sheets-Gmail Automated Realtor Campaign

Заказчик: AI | Опубликовано: 03.02.2026

Gig Title Set Up a 100% Free Google Sheets Automated Email Campaign With Auto Follow-Ups (Gmail) Gig Description I have a realtor email list stored in Google Sheets. I need someone to set up a simple, reliable email automation system that runs directly from Google Sheets using my email address and sends a short campaign email to my list automatically, including scheduled follow-ups. This must be a 100% free setup using Google Sheets and Gmail only. No paid tools, no subscriptions, no third-party platforms like Mailchimp, HubSpot, Instantly, etc. The goal is to contact realtors with a short email offering a product or service, ask a simple question, and then automatically follow up if they don’t reply. What I Need Built I need a Google Sheets system that does the following: It uses my existing realtor email list in Google Sheets. It sends an initial email to each address using my Gmail or domain email connected to Google. It sends automatic follow-up emails on a schedule if there is no response. It stops follow-ups once I mark a lead as responded, or once the sequence is complete. It avoids duplicate sending and keeps everything clean and organized inside the spreadsheet. Email Campaign Requirements The campaign must include: A main intro email offering my service and asking a question. At least 2 follow-up emails spaced out automatically (example: 2 days later, then 4 days later). No personalization is needed. I do not want names or custom fields. Each email should be short, natural, and professional. Spreadsheet Tracking Requirements The Google Sheet must track campaign progress using simple fields such as: Email status (Not Sent / Sent / Follow-Up Sent / Completed / Replied) Date last sent Number of follow-ups sent Next scheduled send date Automation Requirements The automation must be built using: Google Sheets Google Apps Script Time-based triggers (daily or scheduled sending) It must include safeguards to prevent errors, duplicate sends, and accidental mass-blasting. Deliverables When finished, I should receive: A working Google Sheet + Apps Script automation The complete email templates inside the script or sheet Easy instructions showing me how to: Start the campaign Pause the campaign Adjust the follow-up timing Change the email text later Add or remove new emails from the list Important Notes This must stay fully within Google tools and remain free to operate. The developer must test using a small batch first before sending to the full list. The final setup must be simple, clean, and ready to use immediately. Full instructions and or short video of how it works is required. To Apply, Please Include A short description of how you will build it. Confirmation it will be fully free using only Google Sheets + Apps Script. Your estimated delivery time.