I'm actually using this working code and setting a trigger to repeat the task every 4 hours, but I would like to short the code checking every row, let's say look for non empty rows in the range 'A1:A20'. What…
I have an exported product list from Shopify. I need to translate the product description but in the exported description there are HTML codes that Have to stay intact. How do I exclude the code from my translation? I use…
I'm trying sent images chart from Google Sheets to Telegram. I'm saving image chart to Google Disk and then send it to Telegram chat (helping this my telegram bot). If I send Google Drive link to telegram in that way:…
I have a script that creates the client's folder, subfolders, and sheets in the drive whenever I add a new client to the sheet through HTML form. I am looking for a way to add the link in column K…
So I have a script, that sends msg to group chat, if in Column ( 2 ) in any cell's some one printed "Yanson" bot sends only fixed cell - .getRange(row,8). In my case this cell holds link to document.…
Twitter API: https://developer.twitter.com/en/docs/twitter-api/tweets/timelines/introduction In theory, when there is no data, it should leave the value as empty. As seen in this part of the script: if ( obj_data.data[int_i].entities.hasOwnProperty("urls") && Array.isArray(obj_data.data[int_i].entities.urls) && obj_data.data[int_i].entities.urls[0].expanded_url != undefined ) { array_Expanded_url.push([obj_data.data[int_i].entities.urls[0].expanded_url]); } else {…
I found a google sheets app script to export orders from Woocommerce to google sheets using the Woocommerce webhook. After a small modification it looks like this: //this is a function that fires when the webapp receives a GET request…
I have been developing a webhook that receives a json file from a shopify store in google app script. This json file changes its available index depending on what was chosen by the client during checkout. Therefore, before using an…
I need to move rows from a tab based on a cell including "lep". The problem is that it doesn't read the info already on the sheet when it's opened (since it is a sheet that automatically updates new sales…
I have a custom function to send messages to Telegram from values that are in the cells of my table. With Auto Fill Down created at the same time, Telegram warns that it has hit the simultaneous sending limit when…