Both ScriptProperties and ScriptDB are deprecated. Instead, you should be using the new class PropertiesService which is split into three sections of narrowing scope: Document – Gets a property store that all users can access within the current document, if the script is published as an add-on. Script – Gets a property store that all … Read more
It’s the API key as listed under ‘API Access’, the ‘Simple API Access’ box.
Can you share the code with which you are asking for authorization? 9 out of 10 times, if each user in the domain is getting prompted, that is because you are asking for “offline” access. Domain wide authorization cannot be done for offline access. In Python for instance, you can do that like this – … Read more
That error is displayed in case that under “APIs & auth” -> “Consent screen” you have empty field “PRODUCT NAME” – you need to select e-mail address as well. You can find “Consent screen” under a link!, click on project name and then go to “APIs & auth” -> “Consent screen”.
Seems to work for me without the StringIO: test = pd.read_csv(‘https://docs.google.com/spreadsheets/d/’ + ‘0Ak1ecr7i0wotdGJmTURJRnZLYlV3M2daNTRubTdwTXc’ + ‘/export?gid=0&format=csv’, # Set first column as rownames in data frame index_col=0, # Parse column values to datetime parse_dates=[‘Quradate’] ) test.head(5) # Same result as @TomAugspurger BTW, including the ?gid= enables importing different sheets, find the gid in the URL.
There is no need to hardcode all SMTP settings in your code. Put them in web.config instead. This way you can encrypt these settings if needed and change them on the fly without recompiling your application. <configuration> <system.net> <mailSettings> <smtp from=”[email protected]” deliveryMethod=”Network”> <network host=”smtp.gmail.com” port=”587″ userName=”[email protected]” password=”password”/> </smtp> </mailSettings> </system.net> </configuration> End when you send … Read more
So I was half-step close to the solution, the problem was that while creating const jwtClient = new google.auth.JWT(googleKey.client_email, null, googleKey.private_key, [‘https://www.googleapis.com/auth/gmail.send’], null); i did not mention the account to be impersonated. The correct initialization should be: const jwtClient = new google.auth.JWT(googleKey.client_email, null, googleKey.private_key, [‘https://www.googleapis.com/auth/gmail.send’], ‘[email protected]’); To summarize, the correct steps are: Created a project … Read more
Files cannot be uploaded directly by “doPost()” of GAS from HTML form on local PC. Because “multipart/form-data” may be not able to be used for “doPost()”. So converting Base64 leads to the solution as you say. There are 2 ways for uploading files by “doPost()”. 1. Upload a file from HTML form on GAS project … Read more
I found the problem. Previously i was using j2ee.jar to import javax.mail. I removed j2ee.jar from the classpath and downloaded JavaMail 1.4.1 and put into my classpath two jars, smtp.jar and mailapi.jar. I use now smtps instead smtp Transport transport = session.getTransport(“smtps”); Now Bill the Lizard’s code works.
You need to set an admin account with: .setServiceAccountUser(some_admin_email) And make sure your App (with the correct scopes) is granted access in the cpanel.