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?

All responses (1)

Answers (0)

Suggested answer

saurabhtiwarii on at

Like (0)

Report

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

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.