Aggregating Multiple Parser Outputs into a Single Google Sheets Row

How To
, ,
1

Hello Make Community,

I’m trying to set up a scenario where I receive messages from a Telegram group and parse specific details (like Creator Name, Amount, Asset Type, and Transaction Type) using multiple Text Parser (Match Pattern Advanced) modules. Each parser extracts a different piece of data, and I want to aggregate these outputs to add a single row in Google Sheets.

Here’s what I’ve done so far:

  1. Telegram Bot (Watch Updates) sends the message to a Router.
  2. The Router splits the message to multiple Text Parser modules, each parsing a different piece of information.
  3. After each parser, I used the Set Multiple Variables module to store each parsed output as a variable.
  4. Finally, I tried to use a single Google Sheets “Add Row” module to insert all these variables into one row in Google Sheets.

The Problem: The Google Sheets module doesn’t seem to recognize all the variables from the different branches, so I can’t map each parsed field to its respective column. It appears that the variables set in parallel branches aren’t accessible together when adding a row in Google Sheets.

My Questions:

  1. Is there a way to aggregate or combine these outputs into a single Google Sheets module in Make?
  2. Am I missing a step, or is there a workaround to collect the parsed values into one row?
  3. If this approach isn’t feasible on the free tier, would using a Data Store (available in the paid plans) solve this issue?

Thanks in advance for any advice or guidance on how to make this work!

3

Welcome to the Make community!

Yes, use an Array Aggregator, then map+get functions.

For more information, see Mapping with Arrays below.

No, it won’t. Please do the Make Academy.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.