Automating Workflow with Google Sheets, OpenAI, and Gmail

Hello everyone,

I’m looking to create an automated workflow using Make.com that accomplishes the following:

  1. Trigger: When I add a city name to a row in a Google Sheet.
  2. 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
  1. 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.
  2. 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