gscript | Script and script function libraries for GrADS

Currently, I am working with a google sheet using gscript, and I am trying to input data into the cells based on the value within column A of the sheet. The data is pulled through fetching the URI and I am trying to concatenate the URI with the ID located in Column A of the Google Sheet.

I want to take data from Gsheet (city names tab in this sheet), and feed directly this data into some slides in Gslides, following this template for example.

In Gsheet, data is in the same range on each tabs, with the same header. The only thing that changes is the tab name. So [tab name]."{aaa}" for example, in which "{aaa}" would always be in the same range.

The Gslide template would "receive" this data from Gsheet, and pick up the data from either:

• an appended list following the [tab name]."{header}" model.
• directly without creating this appended list if I manage to create a function following the [tab name]."{header}" model.

The End product would be a file in which users can add tabs in the Gsheet file, following the template (ie a city name and the same data in the same range) and feed Gslides through the template, in which they could enter the text they want, following the [tab name].{header} model.

My questions are as follow:

• Which method would be the best and less resources hungry?
• if I choose the list method, How can I append a list from Gsheet using the range from all my tabs that would then be used in the script from Gslide?
• How can I write a function in Gscript in order to populate the data in the slides I will be creating?

I've started writing the folllowing code with help from stackoverflow, but I'm struggling in:

• The order in which I have to do things
• Obviously the function for either the Appended List model / the [tab name]."{header}" model

I feel like this is pretty simple, but I'm missing something. I have 130 folders, all containing the same file, "Document.pdf". Of course, the contents vary from file to file, but they all have the same name and extension. What I'm trying to do is have a script take all those 130 files, and give them names from "1.pdf" to "130.pdf", in order. The folders are in order as well (1-130). I have these folders on both local storage and Google Drive, so any solution involving either bash or GScripts will be good with me. Thanks.

I'm creating a slack slash command and I want to send the body text along the lines of /command send @jay some flowers but I want to send an error is the command contains either no @handles or more than one.

The way I've written the code at the minute uses regex to validate that a handle exists /.*\@.*/ but I am going mad trying to handle the edge cases and get some validation around detecting one and only 1 @ symbol.

I'm validating it in javascript inside a Gscript web service if that's any help

Any thoughts? thx

I have a JSON data like this:

I am trying to solve a task in a project on codeacademy, the task is to find a word in the tsv file which is made to a list with the following code:

A website which displays the truly live sheet (updating instantly when the sheet is changed from elsewhere, like in the editor), but centered on the screen and without menus etc. (like in 2b)

Specifically a website which

• shows a sheet of a Google Sheets spreadsheet, correctly formatted
• updates the sheet live without any user input around once a second
• does not contain Google Sheets editing headers
• centeres the content in the page and has a black border to fill the screen outside of the spreadsheet

After many Google searches, I have found two results lining my goal:

You can directly display the sheet within the editor by simple adding ?rm=minimal to the url as in

https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/view?rm=minimal#gid=SHEET_ID

This

• updates the data truly live, whenever the sheet is changed

but

• shows row and column headers (A, B, C, ..., 1, 2, 3, ...)
• shows sheet selection and "insert x rows below"
• is not centered and does not have a black background

When you edit the URL and replace /edit... with /htmlembed/sheet?gid=SHEET_ID like in

https://docs.google.com/spreadsheets/u/0/d/SPREADSHEET_ID/htmlembed/sheet?gid=SHEET_ID

This

• does not contain any headers or similar
• even allows me to specify only a fixed range to be displayed using the range=A1NOTATION parameter

It can be extended using a GScript WebApp:

(Note that I used green instead of black for visualisation)

Using this URL within a GScript doGet(e) function published as a WebApp allows me to customise it further. I simply added a style-tag to the original source and used background-color as well as flex display to set the background and center the content. This is my function, WHICH IS VERY VULNERABLE TO HTML INJECTION:

I'm trying to create a bot on Slack that sends the data of new messages sent to a private channel (that the bot is in) to a Google Sheet. I was successfully able to do this with data following a Slack slash command, by using this script:

So, I'm currently trying to connect a Lua Script with a GS WebApp. The connection is working but due to my lack of knowledge in GScripting I'm not sure why it isn't saving my data correctly.

In the Lua side I'm just passing in a hard-code a random name and simple numerical userid.