In this article:

How to Send Recurring Emails from Gmail (Easiest Way 2024)

Send Recurring Emails From Google Sheets

Step 1: Create a Lido account

If you don’t already have a Lido account, you’ll need to create a free one here:

Step 2: Set up your recurring email content

Create a new file in Lido.  Then, set up the email subject and body for the message that you want to send on a recurring basis.

Tip: you can add line breaks with cmd+enter on a Mac or alt+enter on a PC.  You can also add more stylings like bold, italics, and hyperlinks by clicking tutorials -> How to add styling to emails.

Step 3: Create your =SENDGMAIL() formula

Next, we will use Lido’s =SENDGMAIL() formula to send this email directly from our spreadsheet.

The formula works as follows:

=SENDGMAIL("sender_email", "recipient_email", "subject", "body")

In our example, the subject and body are in cells B1 and B2. We will reference these in our formula like so:

```=SENDGMAIL("", "", B1, B2)```

You should see a blue action formula.  Remember to replace "" and "" with the actual emails of the sender email and recipient email account in the formula.

Step 4: Run the SENDGMAIL formula

Now let's send an email to test that everything is working properly. Right click on the blue action formula and click Run Action.

If it's your first time sending an email from Lido, you will be taken to a screen to log in to your Gmail account. Make sure that you select the same Gmail account as the one used in the "sender" part of your SENDGMAIL() formula.

After an email has successfully sent, you will see this green success message temporarily in the cell.

Step 5: Automate the SENDGMAIL() formula to send emails on a schedule

Finally, let's automate running the SENDGMAIL formula.

Right click on the SENDGMAIL formula and click Add automation.

This will open the Lido automations panel. Choose a schedule for when you want the emails to recur then click save. There are options for daily automations on a certain time, or weekly automations on a certain date and time.

Then click Save. Your automation to send recurring emails from Gmail is now set up!

We hope that you now have a better understanding of how to send recurring emails from gmail!

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
Creates a one- or multiple-day calendar event with optional attendees
Adds an object to Hubspot
Create a Slack channel, and optionally add a topic or members
Makes any HTTP request
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
Makes any HTTP request and returns the response
Inserts given array below defined values in given worksheet
Sends an email using your Google account
Sends an email using your Microsoft Outlook account
Sends a Slack message
Sends an SMS message using your Twilio account
Updates cells with given values
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started