I want to structure the output from chatgpt and put the different categories in to separate columns in google sheet.
Anyone willing to help?
Welcome to the Make community!
You can either use the Transform Text to Structured Data module
or you can use the Text Parser: Match Pattern module to split the text into bundles.
If you need help with the Match Pattern module, it would be super helpful if you could share the actual text you’re trying to match. Screenshots of text can be a bit tricky, so if you could copy and paste the text directly here, that would be great.
2 Likes
Hi, thanks for the response.
Started with the Transform Text to Structured Data, and get the response I wanted:)
Now my question is. How do I get this in to google sheets? In a structured way.
You have each value in the arrays, please take a look at the following on how to map each value in an array into different fields:
Links
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 —
General
- Help Center | Tutorials
- Make Academy – learn Make and get your certificate ← CHECK THIS OUT
- Make Blog – get the latest updates
- Features & Pricing
Help Center Basics
- Mapping – What is mapping? What can I map? ← CHECK THIS OUT
- Mapping with arrays – How to map items in an array ← CHECK THIS OUT
- Aggregate an array for mapping complex fields
- Tokens for
parseDate| Tokens forformatDate - HTTP modules – Make a request, Get (download) a file
- Webhooks – Error Handling, Responding to webhooks
2 Likes