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…
hy guys im learning google apps script to telegram bot, i have write auto reply command and it success to reply, if i sent @02-02-2021 it will show all recorded data on that day, but on my code it just…
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…
I am having trouble writing my json data to a google sheet - I get the exception "The number of rows in the data does not match the number of rows in the range." I think the problem is with…
So I used this source code to build my telegram bot in GAS, and also used message handler to grab message.message.chat.id in a Google spreadsheet so now what I want is: remove the duplicated chat_ids, because it repeated itself in…
I can't seem to extract the nested data I'm getting from a Shopify orders/create webhook and write it to a spreadsheet. I was able to go down one level by using shift() like this var lineItems = myData.line_items.shift(); but the…
This issue is very similar to others (like Google Drive Page Not Found - Sorry, unable to open the file at this time for example) posted here. It's not exactly the same, but I do believe it has the same…
I am trying to integrate the client side PayPal JavaScript SDK with the PayPal server side REST API. I know how to create a new PayPal order in both the client side JavaScript SDK and the server side REST API.…
I do SEO, and therefore I have a lot of keywords flowing around in different spreadsheets. I'd like a way to filter these into seperate sheets based on specific filters, but I can't for the life of me, figure out…