Questions tagged [py-appscript]
40 questions
0
votes
1 answer
Combining data from multiple sheets with Sheet Name (various names) from each as column A into one main Google Sheet [Google Apps Script]
I have multiple sheets with various names on a Google Sheets document. They are all various names etc.
I'm trying to collate them into one main Google Sheet, with the name of each Sheet as Column A in the main sheet.
Here's an example of the sheet…

kueteo
- 1
- 1
0
votes
0 answers
Creating an email message without opening all the email
I'm trying to automate my Outlook emails with Python on MacOS. I managed to get most of the code working, but there is a slight problem as whenever I run the code, it will pop up all 10-20 emails. How do i achieve the drafting but it doesn't pop out…

BenY
- 1
- 1
0
votes
0 answers
Whats wrong with my PageSpeed Appscript code?
My script used to work, now it seizes to pull any data. I've been trying to resolve the code for some time now and keep getting different errors, so thought i'd post it here.
The script allows field data to be extracted from Google's PSI for a list…

Brandon
- 1
- 1
0
votes
0 answers
Email notification 60 days in advance for subscription renewal
I have a google sheet where I have a list of subscriptions, when the subscription will expire, and another column with the notice date (which is 60 days before the expiration date) so I know I have an upcoming renewal.
I want to get email…
0
votes
0 answers
How do I solve error Unexpected token '=' with AppScript?
I need help with my code. I'm making an appscript to validate some IDs with Google Sheets.
I'm watching this tutorial, I followed the steps and I get this error, I watch the video and it's the same, I don't know what it could be
the error…
0
votes
0 answers
App Script Google sheets sender email id change after the ownership transfer
How to change the sender of the email after the ownership transfer of the app script code in google sheets?
I have transferred the ownership of a Google Sheets App Script code, which sends emails to relevant stakeholders upon certain…
0
votes
0 answers
Discover the function to hide App Script Code in Google Sheet (Extension Menu)
Good day.
I would like to seek your help about some of the features of Appscripts.
Is there any feature to hide the appscript code that is connected with Google Sheet ? e.g if the Apps Script extension can be hidden if it detects that the current…
0
votes
0 answers
Copied data not showing
I wrote an app script to copy data from Sheet1 to sheet2. Both sheets are on the same google workbook. Data on sheet1 was obtained from a sheet3 using the IMPORTRANGE function on google sheet. Sheet3 is on a different workbook. The script executed…

Pest Ingram
- 1
- 2
0
votes
0 answers
How can I solve this google app script function?
I'm trying to extract the trending searches from Google Trends. The first column is working well. But the second and third columns are not providing outputs into Google Sheets.
Here's the code:
function extractTrendingSearches() {
// 1. Visit this…
0
votes
0 answers
How I can do OAuth2 in my app on gmail App Script
We authorize a user visiting our website using OAuth2 and Google;
We get hold of her/his access token that Google returns;
There is a Google Apps Script web app that is executed as the user running the web app;
We want to call this app (3) by…
0
votes
0 answers
Get data from cell and pass to app script and run API when cell gets update
I'm using an app script to get data from cells and pass that data to API. So whenever a color gets the change we have to take that value pass in APIs and store response in G Column. Can someone help
function callNumbers() {
// Call the Numbers…
0
votes
2 answers
Python appscript OSAX display_dialog: how to move it to foreground
I am playing around with the example from here; esp. I have this code:
from osax import *
sa = OSAX()
print sa.display_dialog("Python says hello!",
buttons=["Hi!", "Howdy!", "Duuuude!"],
…

Albert
- 65,406
- 61
- 242
- 386
0
votes
1 answer
Python appscript error: OSERROR: -1700, Can't make some data into the expected type
from appscript import *
ps = app("Adobe Photoshop CS5")
s = ps.current_document.save
s._labelledargterms
Gives:
{'appending': 'DcXt',
'as_': 'fltp',
'copying': 'SaCp',
'in_': 'kfil',
'with_options': 'FmOp'}
I'm not exactly use what the kfil…

Albert
- 65,406
- 61
- 242
- 386
0
votes
1 answer
python appscript for macOS
I am trying to use python package appscript to control applications in my MacBook. Unfortunately I am really confused.
For example, I am trying to control one of my excel files. I want to get the position and scroll to certain roll. Here is my…

liaoming999
- 769
- 8
- 14
0
votes
1 answer
send key code to field
i want to simulate the pressing of the enter key using py-appscript
i already found this, but it seems to only output the newline
Translate Applescrip [key code 125 using command down] to appscript
right now i want to press the enter key after the…

cristopher cutas
- 39
- 10