Scrape Data from Link and create a custom personalized message/sales pitch

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

Created a spreadsheet,
openAI api connection.
failed to setup browse ai.
failed to setup spreadsheet trigger for column F, across entire spreadsheet