Hello everyone,
I’m looking to create an automated workflow using Make.com that accomplishes the following:
- Trigger: When I add a city name to a row in a Google Sheet.
- Action with OpenAI: The city name is sent to OpenAI. OpenAI retrieves a list of colleges in that city, including:
- College Name
- Principal’s Name
- Official College Email Address
- Update Google Sheet: The retrieved information is added to the same Google Sheet. Each college’s details are entered in new rows and appropriate columns.
- Automated Email via Gmail: The updated Google Sheet is connected to Gmail. A pre-written email is automatically sent to each newly added email address. The email may include personalized elements, such as the principal’s or college name.
What I Need Help With: Setting Up the Scenario: How to properly configure this workflow in Make