Category "google-sheets"

Google App Script OCR PDF to text Page Number Limitation

I am very new to Google Script. I have some pdf files in a folder on Google Drive and I am trying to convert pdf to google doc and extract specific text. PDF ha

Automating Google Analytics Data into Google Sheets

I want to automate a report where we want to add 200 rows of data into a spreadsheet, the data in these 200 rows comes from Google Analytics with each row havin

Auto-increment row number from another sheet in INDIRECT formula

I'm working in a google spreadsheet with multiple sheets. This is a situation where I can mess around in a sheet (I call it Sandbox) that I make but can't do an

How to translate only text in formatted HTML code using Google Apps Script?

I have been trying to translate text from HTML code. Here is an example: var s = '<span>X stopped the</span><icon></icon><subject>

Cannot publish Editor addon on google workspace marketplace -Menu options not shown after App is installed. Please ensure that the add-on correctly

I try to publish an Editor Add-on for Google Sheet into the workspace marketplace. But I'm struck on the review. With this message : The App doesn’t meet

Appscript to clear data, Leaving Header (first row) intact

I have a spreadsheet that I would like to create an app script function to clear data/set values from certain cells. It also needs to work up to the last row, a

Is it possible to write vlookup functions in Google's connected sheets?

So there is a requirement to build tables and charts in google sheets with data in bigquery. The data can be brought in to google sheets using connected sheets.

ARRAYFORMULA - get value after certain date

I'm building a sheets with the following pages: Records Team Records Page: Date Time Where User Pay 01/01/2022 01:40 Warehouse Mike Silva 14,00$ 04/01/2022 07:

Need to make simple read and update webapp using appscript

I have a google sheet like this I Need to make a google appscript webapp like below with the above sheet. only the price field need to be editable. When it is

Outer Join in Google Sheets

I have 2 sets of data that I want to do an outer join on (basically include all data from both sets, with empty cells where data is in one set but not the other

Develop automation in Google Sheets to schedule updates in third party database

We have scales for which we upload data based on a Google sheet that we maintain. The Google Sheet translates the data into the correct configuration and we exp

How to get information about all videos of a channel to Google Sheets with Google Apps Script

I want to list all videos of a YouTube channel in Google Sheets and see statistics if possible. How to achieve this with Google Apps Script?

Sum only numbers given a string

How can one create an Apps Script function to sum only numbers given a string. I've been able to do this using this regular formula within Google Sheets: =SUM(S

#DIV error in Google Sheet related to Pivot table

I am trying to fix an error in googlesheet especially related to Pivot table. Especially when I make extra calculations from the Pivot table I get the #Div erro

Google Sheets - Removing the used items from drop-down lists

In Google Sheets I have a column containing a list of available Serial Numbers (say, column A). Somewhere else (say, column B) a user must choose the serial num

comma error while importing csv using appscript to google sheets

I am trying to import a csv file to google sheets via google appscript. everything works well except in the last few rows the data is being copied after skippin

comma error while importing csv using appscript to google sheets

I am trying to import a csv file to google sheets via google appscript. everything works well except in the last few rows the data is being copied after skippin

Auto clear dependent data validation in Google Sheets

I have a Google sheet where I’m using a dependent drop down for users to select one option and then select a second option depending on their first choice

Google Apps Script search function needs to compare strings containing numbers and letters

So I'm building an incredibly simple database (really just a minor in-sheet MVC) to standardize data storage practices in order to automate some things. I'm try

Google Sheets - countif with dynamic range

In sheet1 have a column with a list of IDs, each with a set of statuses: ID Apr May Jun 1 Load Load Complete 2 Load Complete NA 3 Load Load