In today’s fast-paced business environment, staying on top of follow-up reminders is crucial for maintaining strong client relationships and ensuring timely responses. Combining Make (formerly Integromat) with Google Sheets offers a powerful way to automate and customize follow-up sequences tailored to your needs.

Understanding the Tools

Make is a visual automation platform that connects various apps and services, allowing you to create complex workflows without coding. Google Sheets serves as a flexible database where you can store contact information, follow-up schedules, and status updates. Together, these tools enable the creation of dynamic, automated follow-up sequences that adapt to your workflow.

Setting Up Your Google Sheet

Start by designing a Google Sheet that will act as your follow-up tracker. Include columns such as:

  • Name
  • Email
  • Last Contact Date
  • Follow-up Due Date
  • Status

Ensure that the sheet is shared with the appropriate permissions so Make can access and modify it as needed.

Creating the Make Scenario

Log into your Make account and create a new scenario. Begin by adding a Google Sheets module to watch for new or updated rows in your follow-up sheet. Configure it to trigger when a row is added or modified.

Next, add a filter to identify rows where the Follow-up Due Date is approaching or has passed, and the Status indicates that a follow-up is pending.

Automating Reminder Emails

Insert an email module (such as Gmail or SMTP) to send a reminder email to the contact. Personalize the email content using data from the Google Sheet, such as the recipient’s name and the specific follow-up message.

After sending the email, update the Status column in Google Sheets to “Follow-up Sent” and log the date of contact.

Adding Customization and Flexibility

You can extend this workflow by adding delays, multiple follow-up stages, or conditional logic based on responses. For example, if a contact responds positively, you might update their status to “Engaged” and stop follow-up sequences.

Additionally, you can set up recurring checks to ensure no follow-up is missed, making your process highly reliable and scalable.

Best Practices for Effective Follow-Ups

To maximize the effectiveness of your follow-up sequences, consider the following tips:

  • Personalize your messages to increase engagement.
  • Set realistic follow-up intervals based on your industry standards.
  • Regularly review and update your Google Sheets data for accuracy.
  • Test your Make scenario thoroughly before deploying it live.

Automation with Make and Google Sheets streamlines your follow-up process, saving time and ensuring no opportunity slips through the cracks. With a little setup, you can create a tailored, reliable reminder system that adapts to your workflow.