Questions tagged [google-sheets]
Do NOT share spreadsheets/images as the only source of data. Use markdown TEXT tables instead. Use this tag for questions about programmatically interacting with Google Sheets. Use with: [google-apps-script] for questions relating to the built-in scripting language, [google-sheets-formula] for questions relating to formula design or [google-sheets-api] and a language tag (eg:[python]) for questions relating to sheets API usage. Do NOT use with [excel].
google-sheets
55,493
questions
-1
votes
0
answers
10
views
Cannot get .getRange nor .getDataRange to work
I cannot figure out why my script generates the same error regardless of what I try.I have attached a copy of my appscript as well as my google sheet.
Order ID Lineitem sku Email Lineitem name ...
-1
votes
1
answer
15
views
How extract partial data from one sheet to another sheet in Google Sheets
So I have to sheets, Expenses and Tax Expenses Overview. The Expenses sheet has it's data filled via a Google form where I track date of purchase, the category it fits, whether it's tax deductible, ...
0
votes
0
answers
6
views
How can i update data send by Hubspot to a Spreadsheet ? (Google Sheets)
I'm using hubspot CRM to send data daily to my spreadsheet:
In column A it fills with a GCLID
In Column B it fills with nothing
In Column C it fills if a UNIX date value
In Column D it fills with ...
0
votes
1
answer
18
views
How to return number ranking based on criteria?
I've run into an issue that I can't quite figure out. I need to return the placement of a list of values based on a separate criteria.
I have a table that looks like this:
I'm looking for a way to ...
0
votes
0
answers
15
views
How to add recurring bills
Does anyone know how to make recurring bills for a dynamic calendar on google sheets?
I've made the calendar but I don't want to have to always put in recurring bills. I want them to automatically ...
1
vote
1
answer
29
views
HTML Templates Overlapping in Google Sheets
Previously, when I created two HTML templates, opening the second template would automatically close the previous one, ensuring that only one HTML template was visible on the screen at any time. ...
0
votes
1
answer
34
views
Error: Service Invoked too many times (Email Send)
I have a script that gets the specific draft from Gmail to send the email. It sent 10-15 emails and then started throwing error:
Service invoked too many times for one day: email.
Here is the code ...
0
votes
0
answers
11
views
plugin in a Adobe Illustrator or Indesign that can embed in a google sheets
How to embed a google sheets( that has imagem, name, location(type) and level) in a adobe project to make a template by the datas of the sheets.
Tried some pluginXLSX in adobe Illustrator and Indesign ...
0
votes
0
answers
18
views
Why is Google Sheets PHP API failing when I insert a line manually in Google Sheets?
I have a PHP script adding lines to a Google Spreadsheet. It all works perfectly fine.
$client = new Google_Client();
$client->setApplicationName("Google Sheets API");
$client->...
1
vote
0
answers
23
views
DRIVEDIST is throwing error: invalid argument for 'origin'
Trying to implement this into my google sheets document. I keep getting an 'invalid argument' message for line 8, 'origin'. How do I fix this? Also, Google Sheets is not automatically calling this ...
0
votes
0
answers
29
views
Time zone settings in Google Apps Script inaccurate
I can not get google sheets and google apps script to align with the current time zone. Daylight Saving appears to throw it off. Does this happen automatically? Currently, apps script "Central ...
0
votes
0
answers
24
views
Unable to terminate script from executions UI
I'm running into an issue where I am attempting to terminate my script from the executions tab UI, however, when I click on the three dots related to the running unction the terminate option is grayed ...
0
votes
0
answers
8
views
Google sheets and dymo printer
I need to export a csv from google sheets (UTF-8) that can be correctly read by my Dymo printer (ISO-8859-1). I have found there is an issue with special characters eg apostrophies not showing ...
0
votes
1
answer
29
views
Can someone help me fix/improve this code to send automatic emails to clients for their birthdays
Right now the main issue is that it is not recognizing the birthdays and labeling them as invalid. So it is not sending the emails. This is from google sheets to google appscripts.
In the spread sheet ...
0
votes
0
answers
19
views
Google Sheets automate PDF download to PC for selected cells on specific tab
I am new to Google API Scripts and have researched for a couple hours for my specific need. I am unable to piece together my needs, but I am sure it is possible with some help from the experts. Any ...