n8n

How to Automate Gmail Event Newsletter?

Send a monthly email roundup of local events without manual copy and paste. Ideal for venues, promoters, and community managers who need a simple update that goes out on time every month.

A schedule runs once a month at 8 PM. The flow uses a location link you set to load event pages, then reads each page and pulls key details using CSS selectors. It paginates by checking if a page returns 50 items, waits 3 seconds between page loads, and keeps going until the last page. All results are combined, formatted into a clean HTML table, and emailed through Gmail with a subject line that shows the total number of events. This saves hours of manual work and keeps updates consistent.

You only need a valid event listing URL that includes a this month page and a Gmail account for sending. Set your location link and recipient email in the setup step, then activate the workflow. Expect steady monthly sends, less copy paste, and reliable event data in one place. Useful for local listings, fan clubs, and partner newsletters that need a simple monthly digest.

What are the key features?

  • Monthly schedule trigger runs at 8 PM for hands free sending
  • Configurable location and recipient fields stored in a Set node
  • HTTP requests fetch this month pages with automatic page indexing
  • HTML extraction uses CSS selectors to capture event cards and fields
  • Pagination control checks page size and waits 3 seconds between loads
  • Result combiner gathers all split items into one clean dataset
  • HTML builder formats events into a table and counts the total
  • Gmail node sends the newsletter with a clear subject and sender name

What are the benefits?

  • Reduce manual work from 2 hours to 10 minutes by automating monthly roundup emails
  • Send on time every month at a set hour without reminders or calendar tasks
  • Handle large event lists by paging through 50 items per page with safe delays
  • Improve accuracy by pulling details directly from the source page
  • Keep stakeholders informed with a clear subject that shows total events

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Gmail. See the Tools Required section above for links to create accounts with these services.
  3. Open the Set node named Setup location and email. Paste your event location link in the location field. Enter one or more recipient emails in the email field, separated by commas if needed.
  4. Double click the Gmail node. In the Credential to connect with dropdown, click Create new credential and follow the on screen instructions to connect your Google account and allow sending email.
  5. Check the Schedule Trigger. Confirm it runs monthly at 20:00. Adjust the hour if you prefer a different send time.
  6. Verify the event site path matches the expected format that includes this month pages. The HTTP Request node builds URLs like yourLocation/this-month?page=1.
  7. Review the HTML Extract nodes. They expect list items with the CSS selector li.event-listings-element and fields like time, artist, and support. If your site uses different selectors, update them here.
  8. Keep the Wait node at 3 seconds to avoid rate limits. If the site is strict, raise this to 5 or 10 seconds.
  9. Run once manually to test. Check the execution to confirm events are found, collected, and that the HTML builder produces a total count.
  10. Send a test email to yourself. Confirm the subject shows the total events and the table renders correctly in your email client.
  11. If no items appear, confirm the location URL is correct and public. If extraction fails, adjust the CSS selectors in the HTML Extract nodes.
  12. Activate the workflow. Monitor the first scheduled run and review logs in n8n to ensure pagination completes and the email is delivered.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Gmail

Sign up

No cost: Personal Gmail (Gmail API has no usage-based pricing; quotas apply)

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.