How to simplify my Google Sheets to Gmail Scenario

How To
, ,
1

Hi everyone,
I’m new to automation and looking to improve my skills. I’ve built a scenario in Make.com, but I’d love your help simplifying it.

The scenario
The goal of my scenario is to pull sales data from two different Google Sheets — one with product-level data and the other with country-level data. The data is then combined into a gmail that is send to the team every Monday.

What i am hoping to get feedback on

  • Is my scenario too long? It feels like the process is more complex than it should be. Is there a more efficient or shorter approach to achieve this?

  • Is using the Array Aggregator necessary? Or is there a better way to merge data from the two sheets without having to aggregate arrays or create JSON?

  • Is the JSON creation and parsing approach correct? Or is there a third, smarter method that would make the scenario more streamlined?

I’m also curious if there are best practices in Make.com that I might be missing for handling multi-source data, especially when it involves combining data from two sheets into one output.

Any feedback or suggestions would be greatly appreciated! Thanks in advance for your help!

image
image718×369 10.6 KB

image
make.com screenshot
make.com screenshot1798×498 54.2 KB

blueprint.json (63.6 KB)

2

Welcome to the Make community!

To allow us to assist you with your scenario, please provide the following:

1. Relevant Screenshots

Please share screenshots of your scenario, any error messages, relevant module fields, and filters in question? It would really help other community members to see what you’re looking at.

2. Scenario Blueprint

Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

3. Output Bundles of Modules

Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

1 Like
3

Thank you for heads up!
I have now provided a screenshot of the scenario and also ulpoaded an export of the scenario.