<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Sandra Clatiya</title>
    <description>The latest articles on DEV Community by Sandra Clatiya (@mevinu_gamage_d0072ccd415).</description>
    <link>https://dev.to/mevinu_gamage_d0072ccd415</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4247214%2Fc4736e52-9687-44a8-a36a-bdbed62fba56.jpeg</url>
      <title>DEV Community: Sandra Clatiya</title>
      <link>https://dev.to/mevinu_gamage_d0072ccd415</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/mevinu_gamage_d0072ccd415"/>
    <language>en</language>
    <item>
      <title>How to Automatically Parse Gmail Invoices &amp; Receipts into Google Sheets with n8n (Zero Regex)</title>
      <dc:creator>Sandra Clatiya</dc:creator>
      <pubDate>Mon, 16 Nov 2026 08:07:06 +0000</pubDate>
      <link>https://dev.to/mevinu_gamage_d0072ccd415/how-to-automatically-parse-gmail-invoices-receipts-into-google-sheets-with-n8n-zero-regex-53mm</link>
      <guid>https://dev.to/mevinu_gamage_d0072ccd415/how-to-automatically-parse-gmail-invoices-receipts-into-google-sheets-with-n8n-zero-regex-53mm</guid>
      <description>&lt;p&gt;If you've ever tried parsing incoming vendor invoices, receipts, or lead emails inside &lt;strong&gt;n8n&lt;/strong&gt;, you know the pain:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Regex breaks&lt;/strong&gt; the second a vendor changes their email layout.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Full LLM nodes + Structured Output Parsers&lt;/strong&gt; require managing separate OpenAI/Anthropic keys, writing system prompts, and handling occasional markdown backticks that crash downstream Google Sheets nodes.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;In this quick guide, you'll wire up a 3-node n8n workflow (&lt;strong&gt;Gmail Trigger → HTTP Request → Google Sheets&lt;/strong&gt;) that extracts vendor names, invoice dates, currencies, totals, and line items into strict, validated JSON—no OpenAI key required.&lt;/p&gt;




&lt;h3&gt;
  
  
  What You Need
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;An &lt;strong&gt;n8n&lt;/strong&gt; instance (Cloud or self-hosted).&lt;/li&gt;
&lt;li&gt;A free API key for the &lt;strong&gt;&lt;a href="https://rapidapi.com/MevinuGamage/api/structured-json-data-extractor" rel="noopener noreferrer"&gt;Structured JSON Data Extractor API on RapidAPI&lt;/a&gt;&lt;/strong&gt; (includes free calls/month, or test it right in your browser on the &lt;strong&gt;&lt;a href="https://129-203-166-69.sslip.io/" rel="noopener noreferrer"&gt;live playground&lt;/a&gt;&lt;/strong&gt;).&lt;/li&gt;
&lt;/ul&gt;




&lt;h3&gt;
  
  
  Step 1: Set Up the Gmail Trigger
&lt;/h3&gt;

&lt;ol&gt;
&lt;li&gt;Add a &lt;strong&gt;Gmail Trigger&lt;/strong&gt; node in n8n set to &lt;strong&gt;Message Received&lt;/strong&gt;.&lt;/li&gt;
&lt;li&gt;Add a filter query (for example: &lt;code&gt;subject:(invoice OR receipt)&lt;/code&gt;) so it only fires on billing emails.&lt;/li&gt;
&lt;/ol&gt;




&lt;h3&gt;
  
  
  Step 2: Add the HTTP Request Node (Invoice Parser)
&lt;/h3&gt;

&lt;p&gt;Instead of chaining multiple AI and code nodes, drop in a single &lt;strong&gt;HTTP Request&lt;/strong&gt; node:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Method:&lt;/strong&gt; &lt;code&gt;POST&lt;/code&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;URL:&lt;/strong&gt; &lt;code&gt;https://structured-json-data-extractor.p.rapidapi.com/v1/extract/invoice&lt;/code&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Send Headers:&lt;/strong&gt; Enable and add these two pairs:

&lt;ul&gt;
&lt;li&gt;
&lt;code&gt;X-RapidAPI-Key&lt;/code&gt;: &lt;code&gt;YOUR_RAPIDAPI_KEY&lt;/code&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;X-RapidAPI-Host&lt;/code&gt;: &lt;code&gt;structured-json-data-extractor.p.rapidapi.com&lt;/code&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Send Body:&lt;/strong&gt; Enable, choose &lt;strong&gt;JSON&lt;/strong&gt;, and paste:&lt;/li&gt;
&lt;/ul&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;
json
{
  "text": "{{ $json.text }}"
}
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;

</description>
      <category>n8n</category>
      <category>automation</category>
      <category>api</category>
      <category>tutorial</category>
    </item>
  </channel>
</rss>
