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…
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…
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…
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…