Looking for some help to walk through steps of successfully enabling GMail API to send emails from Retool table.
I've followed a few threads (including this one [How to connect to Google APIs]) but continue to run into issues in successfully implementing.
From my Google Console, I've created credentials w/ OAuth2.0 access, copied key and password into the form in appropriate places when adding a resource to Retool, and added scopes as needed.
When I save the resource, add to a query in Retool, and attempt to re-authenticate API, I'm given an error from Google "ERROR 400: Invalid_Request. Missing required parameter: redirect_uri"
Attempting to troubleshoot, I find no area within my REST_API resource to add a Redirect_API or have found a redirect_URI provided by Retool to input in my GoogleCredentials when creating a ClientKey as I've seen available in other tutorials[https://www.youtube.com/watch?v=4x2TVgLZjWo]
I'm rather new to setting up APIs so I apologize in advance if I'm missing something super simple. Any help would be greatly appreciated in helping me solve.
Thanks @byron. I had actually just restarted from scratch after posting and was able to successfully connect and re-authenticate in query editor. However I'm now getting a different error when running the query. I believe it may have something to do with my base_URL and POST methods in the query editor.
Returning error "'raw' RFC822 payload message string or uploading message via /upload/* URL required"
Have attached screenshot w/ query and error message, I have not had luck finding answer in stack forums or continuing to read through GMail API documentation. Any help is greatly appreciated.
Hey @hadenp92, I was building out an internal Retool application that used the Gmail API and ran into the same issue. I solved it by adapting Google's send.js example code.
First, you'll want to create a Transformer to encode your inputs into a base64-encoded message. Using the inputs your provided in the screenshot, it should look something like this:
const to = {{table1.selectedRow.data.Email}}
const subject = 'Your subject'
const body = 'Message body'
const from = 'from-address@example.com'
const utf8Subject = `=?utf-8?B?${btoa(subject)}?=`;
const messageParts = [
`From: ${from}`,
`To: ${to}`,
'Content-Type: text/html; charset=utf-8',
'MIME-Version: 1.0',
`Subject: ${utf8Subject}`,
'',
body,
];
const message = messageParts.join('\n');
// The body needs to be base64url encoded.
const encodedMessage = btoa(message)
.replace(/\+/g, '-')
.replace(/\//g, '_')
.replace(/=+$/, '');
return encodedMessage
You'll then want to update your query. The Body section should have a single raw parameter set to the value of your transformer. I'm assuming that the transformer is named transformer1.
Using this setup, I was able to successfully send an email. I could not figure out how to support the snippet parameter. I also didn't see the contact_name parameter documented for send
You are a life saver, thank you so much for the detailed write up and sharing. I just created the transformer and adjusted the raw parameter you suggested and email came through correctly. Now just need to work on the format a bit, assuming I can do this in the transformer at the 'Content-Type: text/html; charset=utf-8 section?
I'm still working through this one but thought maybe I'm overlooking something simple.
My body string I'm trying to include in email is a {{textinput2.value}} string from a component in the tool. Following your example, the body still comes out with each line having been joined. Am I missing something else?? I'm understanding the const message = messageParts.join('\n'); to be needed for encoding to base64url so this join will need to remain correct. Is there a function i should include in the const body : variable??
As a followup, if you're interested in sending attachments with the Gmail API you'll need to use a different endpoint and slightly different formatting.
Hello, I am trying to attach a file to an email using Gmail API! I followed the example above, however this is what I get as an error ( Attached image)
Would you mind sharing the rest of the view of that query which is hidden under there error there? The base url will be a bit different for sending emails with files (can’t really say why the gmail api is set up like this), and you’ll need to be sure to add a header of Content-Type : message/rfc822
I updated Alexi’s reply here to include the new full transformer code as well for comparison!
Editing this transformer code to add missing line break. Took me 2 days of investigation. rfc822 is particular with the syntax, especially the spacing/line breaks.
const to = {{to.value}}
const from = {{from.value}}
const subject = {{subject.value}}
const body = {{body.value}}
const fileType = {{filepicker1.file.contentType}}
const fileData = {{filepicker1.file.data}}
const fileName = {{filepicker1.file.name}}
const messageParts = [
'Content-Type: multipart/mixed; boundary="message_section"',
'MIME-Version: 1.0',
`From: ${from}`,
`To: ${to}`,
`Subject: ${subject}`,
'', /* <--- this was missing and was causing stress to me */
'--message_section',
'Content-Type: text/plain; charset="UTF-8"',
'MIME-Version: 1.0',
'Content-Transfer-Encoding: 7bit',
'',
body,
'',
'--message_section',
`Content-Type: ${fileType}`,
'MIME-Version: 1.0',
'Content-Transfer-Encoding: base64',
`Content-Disposition: attachment; filename=${fileName}`,
'',
fileData,
'',
'--message_section--'
];
return messageParts.join('\r\n');
rfc822 is particular with the syntax, especially the spacing/line breaks.