Import data from Webhook into GoogleSheet

[Martin_Gauthier]

Hello i have a Glide app webhook that gets data in the following string format:
JP|Anctil|jean_anctil@acme.com|537.50h, Joey |Tremblay|tpjoey@email.com|39.25h, etc…
so its a long text string with columns seperated by |
and rows seperated by ,

Ive tried Create a CSV module, table aggregator etc in between the Glide module and the Google sheet module by i always get the raw data added to a single row.

I would like to parse the text string first by , to have rows, store that into a table/variable, them parse each row with | to create the 4 columns, then add a new row in the google sheet

any help is more then super appreciated

[samliew]

Welcome to the Make community!

What you can do is use an Iterator module with the built-in function split to split the data by comma, then another iterator to split the resulting rows by pipe.

Then array aggregate the second Iterator.

---

Links

Here are some useful links and guides to help you get started and learn more on how to use the Make platform, apps, and app modules —

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?
• Mapping with arrays – How to map items in an array ← CHECK THIS OUT
• Tokens for parseDate | Tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

[Martin_Gauthier]

awesome, got it working with a few other conversion strings. costs a lots of operations on the other hand

[samliew]

If you want us to take a look to see if you can save on operations, perhaps you can share how your scenario looks like now.

Go to the History tab, click on the latest run Details, and take a screenshot.

[Martin_Gauthier]

Thanks Sam, here you go

[samliew]

Hmm looks like you’re trying to add 198 new rows?

While there is no module for that, you might want to try the Bulk Update endpoint for that.

This means you have to aggregate your first iterator, so that the 198 bundles get into the right format for the bulk update endpoint.

Here is an example: How to bulk update non-consecutive rows in Google Sheets using the batchUpdate API?

[Martin_Gauthier]

Thank i will try that later today.
In the same automation , when writing to the google sheet is there a way to clear the sheet (Except header row) before the write so its a fresh view of the data each time?

[samliew]

@AnthonyatXRay that is terrible advice for this particular use-case. A new Google sheet has 1000 rows, are you going to use 1000 operations to clear or delete all of them? If a sheet needs to be cleared in the same way every day of the month, this definitely wouldn’t scale, since you use up all of your operations in just 10 scenario runs.

@Martin_Gauthier

In the same automation , when writing to the google sheet is there a way to clear the sheet (Except header row) before the write so its a fresh view of the data each time?

Yes you can do it in a single operation, also with a similar bulk update endpoint.

However that is a completely new question, could you please create a separate topic for this?

While it’s tempting to continue an existing thread, a more effective approach would be to start a new topic just for your question. It helps community experts find and respond to your query quicker, and keeps our space organised for everyone. If you start a new conversation you are also more likely to get help from other users. You can refer others back to a related topic by including that link in your question. Thank you for understanding and keeping our community neat and tidy.

The “New Topic” link can be found in the top-right of the header: