Exporting Discord channels and their messages each in an individual sheet in Google Sheets

[Adaveo]

I have about 50 channels in my Discord, and I’ve set up a scenario to export messages from these channels into Google Sheets. However, I need to make each channel has a separate sheet with messages.

here is the results

[samliew]

Welcome to the Make community!

You can insert it into the sheet named “channel name”

And if it doesn’t exist, catch the error and use the “Add a Sheet” module to add a sheet.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

[Adaveo]

Thanks, this works, but the sheets should be pre-named with the channel’s name. Is there a way to automate the process of creating a new sheet with the channel’s name and then adding the corresponding messages to each sheet?

i tried this modification but it gives me this error

but I got this error

• The operation failed with an error. 400: INVALID_ARGUMENT - Invalid requests[0].addSheet: A sheet with the name ‘general’ already exists. Please enter another name.

[samliew]

Move this module to the second place.

Add a Resume error handler to this module.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

---

P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!

[Adaveo]

Thanks, sam it is working now