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
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
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.
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!
Thanks, sam it is working now