{"id":46531,"date":"2025-04-07T14:30:52","date_gmt":"2025-04-07T12:30:52","guid":{"rendered":"https:\/\/clicktrust.be\/?p=46531"},"modified":"2025-04-15T16:50:29","modified_gmt":"2025-04-15T14:50:29","slug":"how-to-automate-your-newsletter-with-make-com-chatgpt-google-sheets","status":"publish","type":"post","link":"https:\/\/clicktrust.be\/nl\/blog\/ppc\/how-to-automate-your-newsletter-with-make-com-chatgpt-google-sheets\/","title":{"rendered":"How to automate your newsletter with Make.com, ChatGPT &#038; Google Sheets"},"content":{"rendered":"\n<p>Learn how to automate your newsletter creation using Make.com, ChatGPT, and Google Sheets. Save time by pulling content from RSS feeds, summarizing articles, and organizing it for easy editing and publishing\u2014all with step-by-step instructions.<\/p>\n\n\n\n<p>How to Automate Your Newsletter with Make.com, ChatGPT &amp; Google Sheets<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Newsletter Automation with Make.com\" width=\"1080\" height=\"810\" src=\"https:\/\/www.youtube.com\/embed\/llabpAo_pDM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>If you&#8217;re in digital marketing, content creation, or just running weekly newsletters, you know how time-consuming it can be to curate, summarize, and format content manually. What if we told you there&#8217;s a way to automate most of this process, freeing you up to focus on strategy and creativity?<\/p>\n\n\n\n<p>This guide will walk you step-by-step through setting up a simple, yet powerful automation using Make.com (formerly Integromat), ChatGPT, and Google Sheets to automatically source, summarize, and organize article content for your newsletter.<\/p>\n\n\n\n<p>Let\u2019s dive in.<\/p>\n\n\n\n<p>Tools You\u2019ll Need:<\/p>\n\n\n\n<p>&#8211; Make.com account<br>&#8211; RSS feed URL (example: Search Engine Journal)<br>&#8211; OpenAI API (ChatGPT)<br>&#8211; Google Sheets<br>&#8211; Google Docs (Optional)<\/p>\n\n\n\n<p>Overview of the Automation Workflow<\/p>\n\n\n\n<p>The automation performs the following tasks:<\/p>\n\n\n\n<p>1. Retrieves articles from an RSS feed.<br>2. Extracts and parses article content to plain text.<br>3. Uses ChatGPT to generate a primary text and summary.<br>4. Records all outputs in a Google Sheet.<br>5. Allows manual approval of selected content.<br>6. Pushes approved content into a Google Doc or any other final destination.<\/p>\n\n\n\n<p>Let\u2019s break it down module by module.<\/p>\n\n\n\n<p>Step 1: Set Up the RSS Feed Module<\/p>\n\n\n\n<p><img fetchpriority=\"high\" decoding=\"async\" width=\"486\" height=\"902\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcOsV00odQxt9T0xwJhLFgRpZk1FrTljUBj64A5hWwqdJE2iVh7WN-DEFBAeaTwMBIYXmXyLotJ1clPxVUXXomkrjECUlTgCgUkmauX9Cp7P-gKTjmmRdtpU0oCd5M8g-urP8cgng?key=1j7SebLGKchboeUJCaGXV9Fv\"><\/p>\n\n\n\n<p>&#8211; Create a new scenario in Make.com.<br>&#8211; Add the \u201cRSS\u201d module.<br>&#8211; Choose the &#8220;Retrieve RSS Feed Items&#8221; action.<br>&#8211; Input the RSS feed URL (e.g., from Search Engine Journal or another relevant source for your niche).<br>&#8211; Optional: Limit the number of articles pulled (e.g., 5) to make testing easier.<\/p>\n\n\n\n<p>Step 2: Fetch Article Content with HTTP Module<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfQUelQEJSgyNSg5oUVYgKl9BP9gcHNJ56fkPQEugMXgtPa5wyVJKFNkrPHuOc-JAsF6XQjWoN9lJ3erwyG3xso-PWyZ_Le2vX6e_lwbnNXv50jOXtokzB3ZXPpYtk_XS36vBirjQ?key=1j7SebLGKchboeUJCaGXV9Fv\" alt=\"\"\/><\/figure>\n\n\n\n<p>&#8211; Add an \u201cHTTP\u201d module.<br>&#8211; Action: &#8220;Get a File&#8221;<br>&#8211; Connection: Leave default or as configured.<br>&#8211; For the URL, pull the article link (URL) from the RSS feed item output.<br>&#8211; Tip: Make sure you\u2019re selecting the correct field \u2014 typically the main URL under the author field.<\/p>\n\n\n\n<p>Step 3: Convert HTML to Text with Text Parser Module<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXeDoq3FOqKX7XYWyVqxdXvM7J1f4OWjDcdzO3iHojzcoFWESHoGSX85R2F--ltuLYt7hePP9q95z1_BdfVJbKnwnqB_l5erHRfLlDoOL_VrvzP2lD8TQdrsHSz_5MyZseiJyHNb9w?key=1j7SebLGKchboeUJCaGXV9Fv\" alt=\"\"\/><\/figure>\n\n\n\n<p>&#8211; Add a \u201cText Parser\u201d module.<br>&#8211; Action: &#8220;HTML to Text&#8221;<br>&#8211; Input the data from the HTTP module \u2014 this will convert messy HTML into clean, readable text.<\/p>\n\n\n\n<p>Step 4: Use ChatGPT to Create Useful Content<\/p>\n\n\n\n<p>Now comes the real magic\u2014let\u2019s use AI to extract value from the raw article.<\/p>\n\n\n\n<p>Module 1: Create Primary Text<\/p>\n\n\n\n<p>&#8211; Add the ChatGPT module (Make\u2019s Create Completion module).<br>&#8211; Choose the GPT-4 model (optional: use 3.5 for faster\/cheaper results).<br>&#8211; Prompt GPT to generate a compelling summary or intro paragraph, for example:<\/p>\n\n\n\n<p>Example Prompt:<br>&#8220;`<br>Ignore any metadata and interface guidelines. Analyze the following article content and craft a professional primary text that introduces the article in 1\u20132 sentences.<br>&#8220;`<\/p>\n\n\n\n<p>Module 2: Generate Article Summary<\/p>\n\n\n\n<p>&#8211; Add another ChatGPT module for summarizing.<br>&#8211; Use a prompt similar to:<\/p>\n\n\n\n<p>Example Prompt:<br>&#8220;`<br>Extract the core content from the text below. Ignore navigation menus, sidebars, ads. Analyze the article and provide a clear 2\u20133 sentence summary.<br>&#8220;`<\/p>\n\n\n\n<p>Step 5: Store Results in Google Sheets<\/p>\n\n\n\n<p>&#8211; Add the \u201cGoogle Sheets\u201d module.<br>&#8211; Action: \u201cAdd a Row\u201d<br>&#8211; Input the spreadsheet ID and select the target Sheet.<br>&#8211; Assign the following columns:<br>&#8211; A: Article URL<br>&#8211; B: Primary Text (from ChatGPT)<br>&#8211; C: Summary (from ChatGPT)<br>&#8211; D: (Optional) Approval Field (to be used later)<\/p>\n\n\n\n<p>This gives you a centralized sheet to review articles and decide what to include in your final newsletter.<\/p>\n\n\n\n<p>Step 6: Add Manual Approval via Google Sheets<\/p>\n\n\n\n<p>&#8211; Manually add a new column \u201cApproved?\u201d in your Google Sheet.<br>&#8211; You&#8217;ll use this column to mark articles you want to include in the newsletter.<\/p>\n\n\n\n<p>Step 7: Filter Approved Content and Push to Google Docs<\/p>\n\n\n\n<p>&#8211; Add another &#8220;Google Sheets&#8221; module.<br>&#8211; Action: \u201cSearch Rows\u201d<br>&#8211; Filter rule: Column D = TRUE or Approved = &#8220;Yes&#8221;<br>&#8211; Add a \u201cGoogle Docs\u201d module to push only the approved content to a Doc.<br>&#8211; Repeat this step each time you finalize your newsletter.<\/p>\n\n\n\n<p>Optional Customizations<\/p>\n\n\n\n<p>&#8211; Add other AI tools like MidJourney for generating images.<br>&#8211; Use Perplexity AI to expand articles into longer summaries or blurbs.<br>&#8211; Integrate with Gmail or Mailchimp to send newsletters directly.<br>&#8211; Schedule the scenario to run daily or weekly for up-to-date content.<\/p>\n\n\n\n<p>If you&#8217;d like help building a custom solution for your team or business, feel free to reach out to our team at ClickTrust\u2014we&#8217;re happy to help.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn how to automate your newsletter creation using Make.com, ChatGPT, and Google Sheets. Save time by pulling content from RSS feeds, summarizing articles, and organizing&#8230;<\/p>\n","protected":false},"author":31,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"two_page_speed":[],"footnotes":""},"categories":[425,28],"tags":[],"level":[],"class_list":{"0":"post-46531","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-ai-automation","7":"category-ppc"},"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to automate your newsletter with Make.com, ChatGPT &amp; Google Sheets - Clicktrust<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/clicktrust.be\/nl\/blog\/ppc\/how-to-automate-your-newsletter-with-make-com-chatgpt-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"nl_BE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to automate your newsletter with Make.com, ChatGPT &amp; Google Sheets - Clicktrust\" \/>\n<meta property=\"og:description\" content=\"Learn how to automate your newsletter creation using Make.com, ChatGPT, and Google Sheets. Save time by pulling content from RSS feeds, summarizing articles, and organizing...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/clicktrust.be\/nl\/blog\/ppc\/how-to-automate-your-newsletter-with-make-com-chatgpt-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Clicktrust\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/clicktrustbrussels\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-07T12:30:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-15T14:50:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcOsV00odQxt9T0xwJhLFgRpZk1FrTljUBj64A5hWwqdJE2iVh7WN-DEFBAeaTwMBIYXmXyLotJ1clPxVUXXomkrjECUlTgCgUkmauX9Cp7P-gKTjmmRdtpU0oCd5M8g-urP8cgng?key=1j7SebLGKchboeUJCaGXV9Fv\" \/>\n<meta name=\"author\" content=\"Enrico Cadei\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschreven door\" \/>\n\t<meta name=\"twitter:data1\" content=\"Enrico Cadei\" \/>\n\t<meta name=\"twitter:label2\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minuten\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to automate your newsletter with Make.com, ChatGPT & Google Sheets - Clicktrust","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/clicktrust.be\/nl\/blog\/ppc\/how-to-automate-your-newsletter-with-make-com-chatgpt-google-sheets\/","og_locale":"nl_BE","og_type":"article","og_title":"How to automate your newsletter with Make.com, ChatGPT & Google Sheets - Clicktrust","og_description":"Learn how to automate your newsletter creation using Make.com, ChatGPT, and Google Sheets. Save time by pulling content from RSS feeds, summarizing articles, and organizing...","og_url":"https:\/\/clicktrust.be\/nl\/blog\/ppc\/how-to-automate-your-newsletter-with-make-com-chatgpt-google-sheets\/","og_site_name":"Clicktrust","article_publisher":"https:\/\/www.facebook.com\/clicktrustbrussels\/","article_published_time":"2025-04-07T12:30:52+00:00","article_modified_time":"2025-04-15T14:50:29+00:00","og_image":[{"url":"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcOsV00odQxt9T0xwJhLFgRpZk1FrTljUBj64A5hWwqdJE2iVh7WN-DEFBAeaTwMBIYXmXyLotJ1clPxVUXXomkrjECUlTgCgUkmauX9Cp7P-gKTjmmRdtpU0oCd5M8g-urP8cgng?key=1j7SebLGKchboeUJCaGXV9Fv"}],"author":"Enrico Cadei","twitter_card":"summary_large_image","twitter_misc":{"Geschreven door":"Enrico Cadei","Geschatte leestijd":"4 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/clicktrust.be\/nl\/blog\/ppc\/how-to-automate-your-newsletter-with-make-com-chatgpt-google-sheets\/#article","isPartOf":{"@id":"https:\/\/clicktrust.be\/nl\/blog\/ppc\/how-to-automate-your-newsletter-with-make-com-chatgpt-google-sheets\/"},"author":{"name":"Enrico Cadei","@id":"https:\/\/clicktrust.be\/nl\/#\/schema\/person\/bf07ac7f91b34c401b5f168b492b2f52"},"headline":"How to automate your newsletter with Make.com, ChatGPT &#038; Google Sheets","datePublished":"2025-04-07T12:30:52+00:00","dateModified":"2025-04-15T14:50:29+00:00","mainEntityOfPage":{"@id":"https:\/\/clicktrust.be\/nl\/blog\/ppc\/how-to-automate-your-newsletter-with-make-com-chatgpt-google-sheets\/"},"wordCount":757,"publisher":{"@id":"https:\/\/clicktrust.be\/nl\/#organization"},"articleSection":["AI Automation","PPC"],"inLanguage":"nl-BE"},{"@type":"WebPage","@id":"https:\/\/clicktrust.be\/nl\/blog\/ppc\/how-to-automate-your-newsletter-with-make-com-chatgpt-google-sheets\/","url":"https:\/\/clicktrust.be\/nl\/blog\/ppc\/how-to-automate-your-newsletter-with-make-com-chatgpt-google-sheets\/","name":"How to automate your newsletter with Make.com, ChatGPT & Google Sheets - Clicktrust","isPartOf":{"@id":"https:\/\/clicktrust.be\/nl\/#website"},"datePublished":"2025-04-07T12:30:52+00:00","dateModified":"2025-04-15T14:50:29+00:00","breadcrumb":{"@id":"https:\/\/clicktrust.be\/nl\/blog\/ppc\/how-to-automate-your-newsletter-with-make-com-chatgpt-google-sheets\/#breadcrumb"},"inLanguage":"nl-BE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/clicktrust.be\/nl\/blog\/ppc\/how-to-automate-your-newsletter-with-make-com-chatgpt-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/clicktrust.be\/nl\/blog\/ppc\/how-to-automate-your-newsletter-with-make-com-chatgpt-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/clicktrust.be\/nl\/"},{"@type":"ListItem","position":2,"name":"Brainfood","item":"https:\/\/clicktrust.be\/blog\/"},{"@type":"ListItem","position":3,"name":"AI Automation","item":"https:\/\/clicktrust.be\/category\/ai-automation\/"},{"@type":"ListItem","position":4,"name":"How to automate your newsletter with Make.com, ChatGPT &#038; Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/clicktrust.be\/nl\/#website","url":"https:\/\/clicktrust.be\/nl\/","name":"Clicktrust","description":"We are CLICKTRUST. Full transparency","publisher":{"@id":"https:\/\/clicktrust.be\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/clicktrust.be\/nl\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"nl-BE"},{"@type":"Organization","@id":"https:\/\/clicktrust.be\/nl\/#organization","name":"Clicktrust","url":"https:\/\/clicktrust.be\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-BE","@id":"https:\/\/clicktrust.be\/nl\/#\/schema\/logo\/image\/","url":"","contentUrl":"","caption":"Clicktrust"},"image":{"@id":"https:\/\/clicktrust.be\/nl\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/clicktrustbrussels\/","https:\/\/www.youtube.com\/channel\/UCKKPuTA6ssQo_w1Kzs9Ldwg","https:\/\/www.linkedin.com\/company\/clicktrust-marketing\/","https:\/\/instagram.com\/clicktrust?igshid=YmMyMTA2M2Y"]},{"@type":"Person","@id":"https:\/\/clicktrust.be\/nl\/#\/schema\/person\/bf07ac7f91b34c401b5f168b492b2f52","name":"Enrico Cadei","image":{"@type":"ImageObject","inLanguage":"nl-BE","@id":"https:\/\/clicktrust.be\/nl\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2d2b4074a32e00487db8bac9ac404127860162ef7fe5675afa0b327ad69502ec?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2d2b4074a32e00487db8bac9ac404127860162ef7fe5675afa0b327ad69502ec?s=96&d=mm&r=g","caption":"Enrico Cadei"},"description":"Digital Performance Analyst","url":"https:\/\/clicktrust.be\/nl\/author\/enrico-cadei\/"}]}},"_links":{"self":[{"href":"https:\/\/clicktrust.be\/nl\/wp-json\/wp\/v2\/posts\/46531","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/clicktrust.be\/nl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clicktrust.be\/nl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clicktrust.be\/nl\/wp-json\/wp\/v2\/users\/31"}],"replies":[{"embeddable":true,"href":"https:\/\/clicktrust.be\/nl\/wp-json\/wp\/v2\/comments?post=46531"}],"version-history":[{"count":0,"href":"https:\/\/clicktrust.be\/nl\/wp-json\/wp\/v2\/posts\/46531\/revisions"}],"wp:attachment":[{"href":"https:\/\/clicktrust.be\/nl\/wp-json\/wp\/v2\/media?parent=46531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clicktrust.be\/nl\/wp-json\/wp\/v2\/categories?post=46531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clicktrust.be\/nl\/wp-json\/wp\/v2\/tags?post=46531"},{"taxonomy":"level","embeddable":true,"href":"https:\/\/clicktrust.be\/nl\/wp-json\/wp\/v2\/level?post=46531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}