All Questions
17 questions
-2
votes
1
answer
194
views
Copy paste values of specific cells in same Google sheet
I have a Google sheet I want to move only values of specific cells to specific cells from one tab to another at required destination only when I will click a move button present in the tab
How will it ...
0
votes
0
answers
168
views
How do I resolve a 403 for accessing Sheets API via Python
I am trying to build a script on my local machine using Python that will download a Google sheet from my account using a short lived federated identity token. I have seen documentation that speaks ...
- 111
2
votes
1
answer
1k
views
Python for Google Sheets: Create new sheet (in the same workbook) automatically and write a new dataframe into it
I have a loop that runs 'n' times and generates 1 new dataframe in each iteration. How can I automatically create a new Google sheet (in the same workbook) every time a new dataframe is created at the ...
- 456
1
vote
1
answer
907
views
Iterate through all previous versions of Google Sheets
I want to iterate through all previous versions of a Google sheet and extract some information from all the versions along with version timestamp.
Is there any easy to do so? I couldn't find any API ...
- 174
0
votes
0
answers
60
views
Analogue of the sheet.createTextFinder('somestr'); in Google-Sheets Python API
Does Google-Sheets Python API have same function like createTextFinder()?
Here is a sample code for Google-Script:
function findINSheet(sheet, someStr){
var tf = sheet.createTextFinder(someStr);
...
- 1
-1
votes
1
answer
546
views
In the Google Sheets API, how to delete all existing FilterViews?
I'm using the Google sheets API and have a sheet that I'd like to refresh monthly which would include deleting all the filter views and then recreating them. I know how to create them, but googles ...
- 1
3
votes
1
answer
8k
views
Update google sheet from python script
I'm trying to have a python script update a google sheets. The script scrapes a dynamically loaded webpage and retrieves some values.
Because the site loads dynamically, I can't use google scripts. ...
- 49
0
votes
0
answers
145
views
Having Twilio call 1 number, get the call status and then proceeding to call the next number on Apps Script
I have a list of phone numbers to call on google spreadsheet and I have coded up on apps script to call the numbers.
However, I would like twilio to be able to call the first number, get its call ...
- 13
0
votes
1
answer
295
views
Can i use an external program to run custom scripts in google sheets?
TLDR; Can a .py script run a Google Apps Script?
Hi!
By using Google APIs I've managed to create a .py script that can access and edit a google sheet. I then want the program to be able to select a ...
- 11
1
vote
1
answer
566
views
Retrieve multiple fonts data from within a cell
A cell in a google sheet can have multiple font colors (or other rich text properties) in it along the string stored within.
It can also be done with the API through the property TextFormatRun as ...
- 821
1
vote
0
answers
129
views
Attempting to add an external user but receiving the following error (Error 403: org_Internal)
One of my colleagues has a Python script for one of our projects that accesses files in Google Drive and edits them (renaming, copying, sharing/unsharing). The application requires OAuth2 ...
- 11
0
votes
2
answers
267
views
How to show date value in another format (python date to text) on worksheet
I am using the Google Sheets API for inserting some data on my sheet.
Every row has a date cell that has values in this format "2017-02-01 19:33:56+00:00" I would like it to display it in this format (...
- 610
4
votes
1
answer
4k
views
Copy spreadsheet sheet to a another one with Google API using Python
I am trying to create a google spreadsheet from a template and then edit its values (cells). Manually, I just visit the original spreadsheet and click Make a copy from the File menu. I have not found ...
- 2,886
0
votes
2
answers
8k
views
Running python script from Google Apps script
I have a python script (on my local machine) that queries Postgres database and updates a Google sheet via sheets API. I want the python script to run on opening the sheet. I am aware of Google Apps ...
1
vote
1
answer
375
views
Google APIs (gmail and spreadsheet): what more should I set up, or to know what setup I'm missing?
I'm creating a webapp, that includes some cron jobs, which would call the gmail API, and the google spreadsheet API.
I've created a project in my google developers deashboard, and credentials for it, ...
- 7,632