Skip to main content

Hey there everyone, 

Is there a way to connect a Google sheet into an Acumatica screen to get real time data?  

Acumatica, specifically Generic Inquiries, supports OData.

This describes how to expose a GI to OData.

This describes how to connect Sheets to an OData feed.


Thanks for the info.  Time to start playing!!!!


This doesn’t seem to work. 

For example, see: https://www.augforums.com/forums/acumatica-odata-with-microsoft-excel-and-power-bi/connecting-acumatica-to-google-sheets-via-odata-feed/

Has anyone gotten it to acumatica to google sheets to work? 


@dcobey yes I posted that in AUGforums because I was hoping someone else had discovered a way to do it. So far I have yet to see a path. Thanks for pressing on this all!


Reply