Overcoming Challenges: Accessing Google Sheets Module in Make

Are you new to Make and finding it challenging to access the Google Sheets module to use the other data in the Ship Station module? Don't worry, you're not alone. This is a common issue that many users face when they start using Make. But the good news is, there's a solution.

Understanding the Problem

Let's say you have a Google Sheet with several columns, and you need to turn SKU1-3 into Item Orders. You've successfully done this with a workflow, but since modifying and adding modules in the middle, you can no longer access the Google Sheets module to use the other data in the Ship Station module.

The Text Aggregator is used to make a JSON array of data based on the three SKU column combinations. You then parse that as JSON and run it through the Array Aggregator to map over the array of SKU data to make Ship Station Order Items. But the Ship Station module is only giving the same 2 modules as Sources.

The Solution

The solution to this problem is to not use a Text Aggregator and instead just Compose a String as text and insert that in place. This way, you can take the same code in the old Text Aggregator and put it in the Compose a string module.

Step-by-Step Guide

  1. Start by copying the exact same text shown in your old Text Aggregator.
  2. Next, paste this text into the Compose a string module.
  3. Run the workflow again. You should now be able to access the Google Sheets module to use the other data in the Ship Station module.

Troubleshooting Tips

If you're still having trouble, try hitting “Run Once” so it can redetect the outputs from the bundles again. Also, remember that with JSON, pretty much everything (keys & values) need to be wrapped in double quotes ". And you can't have any returns, keyboard return, or it adds in \n and that is invalid in the json.

Conclusion

While Make can be a bit challenging to navigate at first, with a bit of practice and the right guidance, you can overcome any hurdles. Remember, the community is always here to help. So don't hesitate to ask for help if you need it.

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.