Scrape Data from Link and create a custom personalized message

How To
,
1

What are you trying to achieve?

When a website link is added to Column F, the system:

  • Scrapes the website’s data (text + emails + subpages).
  • Generates a custom message (pitch).
  • Outputs:
    :e_mail: Column D → All emails found on the site (comma-separated).
    :memo: Column E → Custom AI-generated pitch.
    :link: Column F → Website URL (trigger column).

Steps taken so far

added Watch new rows module for sheets, (not working as expected)
openAI api connection. (done)
web parsing (done).
failed to setup spreadsheet trigger for column F, across entire spreadsheet

2

Since you’re Using the watch new rows trigger, use the watch changes module instead.

3

Did you add a script in google sheets?

You can split the scenario into two.
The first adds the info to the google sheet.
The second starts when changes in the sheet are made.

I use the attached script. When column H is changed, my second scenario starts.
googleSheetScriptWatchColumn.txt (2.1 KB)

I use it for automated invoice generation, but should also work for your task.

4

Why not just call the other scenario if the first system is also done in Make?

To do this, you can try using the Scenarios “Call a subscenario” module —

Calls a subscenario from a scenario flow, and lets you send and receive data between the two.

For more information about the Call a subscenario module and Scenarios app, see the corresponding Integrations page and the Help Centre documentation.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew