Solving Make.com User's Challenge: Google Sheets to ChatGPT

Problem: Turning Multiple Google Sheets Rows into One Curated Summary

Have you ever found yourself in a situation where you have a bunch of news articles located in a few rows in Google Sheets and you want to convert them into a curated news summary to post on social media? Well, you're not alone. This is a common challenge for many Make.com users.

Let's say you have set a Google Sheets trigger to check for rows that have column D checked. Some days, you have 3 rows checked, some days you may have more. The problem arises when you want to transfer these rows as one single package to the ChatGPT module. Because the Google Sheets module would return 3 bundles (or more), and with the variables provided, ChatGPT could only read the 1st bundle and ignore the rest.

Solution: Using Google Sheets Search Rows Module and Text Aggregator

The solution to this problem is simpler than you might think. You can use the “Google Sheets: Search Rows” module and then connect a text aggregator to aggregate all data from the specific column with the required separator.

Here's a step-by-step guide:

  1. Use the “Google Sheets: Search Rows” module to search for the rows you want to aggregate.
  2. Connect a text aggregator to the Google Sheets module.
  3. In the text aggregator settings, choose the specific column you want to aggregate.
  4. Choose the required separator. If you want to use a new line as a separator, you can choose the Newline option in the Row separator instead of Other.

Troubleshooting Tips

If you're still having trouble with this process, here are a few tips:

  • Make sure you have the correct permissions to access and modify the Google Sheets document.
  • Ensure that the Google Sheets module is properly connected to the text aggregator.
  • Check that you have chosen the correct column in the text aggregator settings.

Conclusion

Turning multiple Google Sheets rows into one curated summary doesn't have to be a daunting task. With the right tools and steps, you can easily aggregate your data and create a comprehensive summary for your social media posts. Remember, the key is to use the “Google Sheets: Search Rows” module and a text aggregator with the correct settings. Happy summarizing!

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.