• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

  • Due to local holiday, the Pabbly office will remain closed on 30th of March 2023.

    The office will reopen on the 31th of March 2023 at 10 AM (Indian Standard Time) / 12:30 AM (EST).

Google Sheets to Microsoft Office 365 integration

ghalitzka

Member
I'm working on an integration between Google Sheets (Trigger: New or updated spreadsheet row) and Microsoft Office 365 (Action: Send mail to multiple users).

I'm using the concatenate function in Sheets to format emails properly to transmit to Outlook in the format:
{"emailAddress": {"address": "[email protected]"}}

Then I'm using TEXTJOIN to combine multiple addresses with a comma separator. So the result looks like this:
{"emailAddress": {"address": "[email protected]"}},{"emailAddress": {"address": "[email protected]"}}

So long as I'm combining at least two addresses, everything works great! But when I try to send a message to a single address, something in the chain (I suspect it's Google Sheets, but it could also be Pabbly) is stripping off the proper formatting.

Instead of looking like this:
{"emailAddress": {"address": "[email protected]"}}

The email is sent to Office 365 in a "plain" format like this:
[email protected]

That triggers an error in Office when I try to send the message because the address is not properly formatted.

Could you give me any pointers on how I might be able to resolve this, so that Office 365 receives a properly formatted email address, even when there's only a single address involved?
 

Supreme

Well-known member
Staff member
Hey @ghalitzka

Could you give me any pointers on how I might be able to resolve this, so that Office 365 receives a properly formatted email address, even when there's only a single address involved?
As we can see from your recent task history you have properly managed to pass the email address in the given format.

1672035019243.png
 
Top