How to create plug-in to async data between dynamic 365 & google sheets

(0) Share

Report

Posted on by Community Member

I've already started to create it:
The api is available for google sheets but requires Oauth and so needs to open a port in dynamics,how can it be handled in this case?
Do you have other ideas, or simpler options?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

saurabhtiwarii on at

Like (0)

Report

Hello Abu,

I believe you may go for a simpler option which would be to utilize Microsoft Connectors for Google sheet. This may also potentially reduce the load on CRM ::

This connector is available in the following products and regions ::


Service	Class	Regions
Logic Apps	Standard	All Logic Apps regions except the following: - Azure China regions
Power Automate	Standard	All Power Automate regions except the following: - US Government (GCC High)
Power Apps	Standard	All Power Apps regions except the following: - US Government (GCC High)

Available Actions ::


Delete Row	This operation is used to retrieve a row from a Google Sheet.
Get row	This operation retrieves a single row from a Google Sheet.
Get rows	This operation retrieves the records from a specific Google Sheet.
Get sheets	Retrieves sheet names from a Google Sheet file
Insert row	This operation is used to insert a new row in a Google Sheet.
Update row	This operation updates a row in a Google Sheet.