I tried to pull data from the API of twitter and put in google sheet using appscript, with the next code was supposed that give to me 15 rows with different information in each column and it dont's, only give…
I´ve been cracking my head for days to find the most elegant way to parse a Json string and write it to google sheets. It derives from a webhook off woocommerce. I have a Json like the following: "product_variations": […
I'm currently creating a Google Apps Script for my company. We're a marketing agency in control of many Facebook ad accounts. Shortly, we have to update numbers on our own Google Sheet with spending from the clients ad accounts every…
This is what the product details for one of our products look like and is formatted before we import it into Shopify to be shown on our e-com store: <ul> <li>Comfort: waterproof, windproof, lightweight, engineered ventilation</li> <li>Material: 100% polyester with…
I have a code that would take an excel sheet and convert it to google sheet. It is working but only copying the values. How can I copy the styling and range (merged cells) also to google Sheets? Is there…
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.…