Skip to content
Advertisement

How to use Class range when coding in apps script

I’m building a Slack Bot for my internship, and I can get it to send direct messages to a private channel, and connect through the API. But my current problem is getting the algorithm to take the information in a spreadsheet and form a message with that data in the channel. I found a tutorial on youtube, and their code looks like this, I need to understand what this code is doing, please help!

JavaScript

Advertisement

Answer

Getting data from Spreadsheet and iterating over it

JavaScript

Data:

COL1 COL2 COL3 COL4 COL5
12 3 19 14 5
9 6 15 4 15
13 7 9 14 6
17 17 7 11 0
16 4 18 14 17
JavaScript
User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement