Q: Scraping lead information
Hi I am interested to use the tool to automate some of my tasks.
I would like to automate the following process and would like to know if Smart Spreadsheets would be able to do so.
I would like to generate personalised cold emails at bulk.
I have the email and website urls for the targeted companies. I would like to use chatgpt to customise the cold emails based on the services we provide (i would like to give a url of our site or a description of the services to promote), I would like the target website to be scraped and a customised cold email message (title and body) to be generated for each website based on the website contents and my service information. Can I use SMTP to send emails from my non Gmail address?
Regards
Daniel
Sohails
Apr 1, 2025A: Thank you for your interest in Smart Spreadsheets! Let me clarify what's possible with our tools:
Yes, we can help automate your cold email process with these features:
# Bulk email sending through Gmail
# Email personalization using data from your spreadsheet
# Multiple follow-up sequences
However, please note:
Emails must be sent through Gmail/Google Workspace (SMTP is not supported as this runs within Google Sheets)
While we don't currently have built-in website scraping + ChatGPT integration, you can:
# Use our separate SERP Data Scraper tool to gather website data
# Import the personalized content into the spreadsheet for sending
Here is the specific video: https://www.youtube.com/watch?v=ZNsEhu_z31s