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…
I'm trying to get content of XML file from URL to Google Sheets using Apps Script (JS) Unfortunately URL has lots of strange redirects and I have no impact on this on server side. I need to handle it by…
I need to be able to automatically update a google sheet file every time an order is placed through WooCommerce. I've found the solution below, but using this each individual item ordered is listed as a new row. I'd like…
After a PayPal order is complete, it sends a webhook to a google script URL. Before information is sent, it has to validate the signature. Down below is a link to a Java example. https://developer.paypal.com/docs/api-basics/notifications/webhooks/notification-messages/# How to validate a PayPal…
I am writing a google app script that works with telegram. The user will key in their unique 4 digit code and it will run against my array. i have most of the stuff working. I'm currently stuck getting my…