Time variable

How do I make it so that every date is different for each customer’s automatic email?

I have all emails and check in dates for a hotel in a google sheet, is it possible to use that as a data source to make it so that the automation works once per day and only sends the email 2 days before each different check in date? If so, could you explain how to make that work?

We’d love to help, however, you have not provided sufficient information to demonstrate the problem that would allow us to reproduce the scenario and any issue/s and/or error/s.

To allow others to assist you with your scenario, please provide the following:

1. All Relevant Screenshots

We need to see what you’re working with to give you the best advice. Screenshots are extremely important because Make is a visual editor — a picture provides us with more context.

It would help us identify the issue by having screenshots of:

  • the full scenario,
  • any error messages,
  • individual module fields,
  • relevant filter settings (conditions), and
  • each module’s output bundles
  • any external services (spreadsheet headers, sample data, regex101.com, etc.)

Sharing these details will make it easier for others to assist you.