I have been working on a google sheet(sheet A) where the data comes from another sheet(sheet B) through importrange. In sheet A, column A contains all the urls, col C is the keywords and col F SEO keywords. I want…
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…
Anyone can help me with this regular expression? I need to extract the price from a list of items. <span class="woocommerce-Price-amount amount"><bdi>22,21<span class="woocommerce-Price-currencySymbol">€</span></bdi></span>. I found this, but I am not extracting the ",". =REGEXREPLACE(H8;"D+"; "")*1
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…
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…
Would it be possible to use Shopify's API to send each of our Shipping Profiles (including all products by title and/or sku) to a separate Google Sheets file and have them synced one way from Shopify to Google Sheets? I…
In my example: https://docs.google.com/spreadsheets/d/1QQNTw_r9-q-FqVNwUoYklup73niZCFyO0VDUYImP5fo/edit?usp=sharing I'm using Google Forms as an eBay clone to sell rare items. Each bid is outputted from the form to the "Data" worksheet and then I have ArrayFormulas set up inside the "Processed" worksheet. The idea…