Send personalized emails to each person on the spreadsheet

Tailor your communication without lifting a finger

  • Execute the task periodically
  • Extract the next new row (gspreadsheet → read_row)
  • Send an email (gmail → send)
  • Clear a row (gspreadsheet → clear_row)

Manually sending personalized emails to every new contact in your spreadsheet eats up hours—copying addresses, tweaking details, hitting send over and over. This process is not only tedious, but it also leaves plenty of room for costly mistakes and missed follow-ups. When you don’t automate, you pay in wasted time, lost deals, and a lack of consistency in your client communications, which chips away at your professional image.

Botize’s formula instantly transforms this grind into a seamless workflow: it scans your Google Sheet every few minutes for new contacts, pulls in all the necessary details, and sends out tailored emails through Gmail, complete with the recipient’s name and data from your sheet. Each row is processed only once, then automatically cleared—so no risk of duplicate mails. You stay in control, able to set how often messages go out and which data triggers the emails. The result? Hours gained back each week, error-free and timely contact, and that ‘big company’ touch your customers notice.

Ready to automate your personalized email follow-ups with Botize? Follow the step-by-step guide or jump straight to the prebuilt formula to start saving time and impressing your clients right away. Your next level of productivity is one click away—let’s get moving!

Automate this task with 4 simple prompts

Copy and paste the following prompts into Botize's AI task editor

  1. 2

    Select the AI editing tool.

    AI Prompt Tool
  2. 3

    Start by making sure the automation runs regularly to check for new people to email.

    Copy and paste this prompt into the AI editing tool.

    Set up the automation so it triggers every 5 minutes. —

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  3. 4

    Next, let's get the details of the next new person added to the spreadsheet.

    Copy and paste this prompt into the AI editing tool.

    Add a step to pull the next new row from the Google Sheet, making sure to only grab rows that haven't been processed yet. —

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  4. 5

    Now, send a personalized welcome email to the new person with their details included.

    Copy and paste this prompt into the AI editing tool.

    Add a step to send an email from info@mycompany.com to the person's email address from the spreadsheet, using a template that fills in their name, email, and address from the row. —

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  5. 6

    Finally, mark that person as processed in the spreadsheet so they don't get another email.

    Copy and paste this prompt into the AI editing tool.

    Add a step to clear or flag the row in the Google Sheet after the email has been sent so it won't be processed again. —

    AI Prompt Tool

    Click the 'Apply this task' button to confirm.

  6. 7

    Your automation is ready to use. Click the 'Save changes' button.

    Save changes

Effortlessly Send Personalized Emails

Upload your email list, let us handle the rest. Each person gets a uniquely crafted email from you.

Manual Botize
Finding individual emails 15 minutes 0 Minutes
Crafting personalized messages 20 minutes per email 0 Minutes
Sending each email 5 minutes 0 Minutes
Total Several hours depending on list size 0 Minutes

You've found the ultimate solution for personalized outreach.


Onboarding New Clients

Automatically send each new client their welcome email without manually tweaking the message for each one.

Save Time

Cut hours down to minutes with automated emailing

Boost Engagement

Personalized emails increase response rates

Stay Organized

Effortlessly manage your email communication


Follow-up Made Easy

Easily follow up with event attendees by emailing directly from your RSVP list.

📈

⌟ You manage client lists and thrive on efficiency

⌟ You're looking to personalize without the hassle

🛑

✕ You send one email a year

✕ Your email list comprises of less than three people


✓ Choose how often emails are sent (e.g., weekly, monthly)

✓ Adjust the email template to match your brand voice

✓ Filter which list segments receive emails based on specific criteria




Related automations