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…
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…