Category "google-sheets"

Get the email address of a "people chip"?

Does anyone know if there is a way to use the Google Sheets API to get the email address of a people chip? It seems like the only values it will give me are the

There is a way to set the pdf size in the following script?

How do I set the pdf size as A4 in the following script? Also, is it possible to fit the sheet into a single pdf page? function sendSheet() { var message = {

Google Sheets keeps sending emails

Been building a landing page to start an email list. Decided to use Google Sheets as the backend to store emails & Google Scripts to send the first welcome

Mail merge with different attachments

Please guide me. For how to fix the script to different attachments. In other parts of script is perfected. I want to solution for attachments. See code here

REGEXEXTRACT between strings but only display numbers in Google Sheets [closed]

I have a Google Sheets formula below, which extracts the contents between a multi line string: =REGEXEXTRACT(A2, "(?ms)mystring1(.*)mystring2"

Google Sheets SUM() does not return zero, but an extremely small number instead?

I have a Google Sheet with the following values: 12.4840 -8.1870 -0.9630 -3.3210 3.4550 0.3140 3.3470 -7.1290 If I SUM() these, the expected result

what is the google sheets importData timeout

I can't seem to find any documentation on what the timeout is for the =ImportData function for google sheets. I have a url that return in 10 seconds and it wor

what is the google sheets importData timeout

I can't seem to find any documentation on what the timeout is for the =ImportData function for google sheets. I have a url that return in 10 seconds and it wor

Sort/Order query result based on calculated fields

I have a list of transactions in Transactions tab and in Summary I would like to summarize by tickers the performance. I am using query for grouping the data an

Google Sheets : How to add the same rows everytime i add a value in a column?

I'd like to know if there is a formula or a way in google sheets that : 1/ for each value "sku" and "princing" I have a dedicated set of "rows" that replicate t

Importing API data via importJSON

Having a bit of trouble using importJSON for the first time in Google Sheets. My data is importing as truncated and I can't find any way to really filter things

I cant import data from another big sheet

Im having trouble importing data from my another sheet. Its quite big, has over 500 rows and to 100 columns. (I dont know if thats important but it has about 50

What is the problem with inserting dividend from finviz.com to Google sheets?

I use this formula to get dividend: =IfError(IF(isblank(A2),"", substitute(index(IMPORTHTML("http://finviz.com/quote.ashx?t="&A2,"table", 8),7,2),"*","")),0

Apps Script google.script.run does not work within a Library-bound html file when triggered by other users

I have an authorization problem, but I can't figure it out. I have 50+ spreadsheets each for a separate user in our company. Each user spreadsheet has a contain

DSUM with multiple criteria

I'm trying to get the sum of all items in column F:F when Column J:J = "Channel"and Column K:K = "Country" =DSUM(Sheet1!$A$1:$K$142,Sheet1!$F$2:$F$142,{{Sheet1

Sync Google Sheet and Google Calendar by ID preventing duplicates

With this code I could put the events from google spreadsheet to google calendar, but now I would to sync these events between the two platforms by a unique ID

Why does my INDEX MATCH formula not work on Google Sheets?

So I am having some issues with extracting the correct data to the "Battery Logs" Sheet from "FC" Sheet. I am trying to copy the data from the column range C2:D

Google Sheet to Laravel 8 Integration

I want to integrate google sheet with Laravel 8 without any third party tool or connector. I know its simple for many but i am not able to get through. Highly a

Google Sheet to Laravel 8 Integration

I want to integrate google sheet with Laravel 8 without any third party tool or connector. I know its simple for many but i am not able to get through. Highly a

Import a Coingecko table to Google Spread Sheets

I want to import the TOP LOOSERS table from this page to a Google Spreadsheet but I have no idea whatsoever how to do it.