Ideas for Acumatica

Feedback processing: We do not reply to all messages, but we do read them, analyze them, and work to improve Acumatica based on the feedback we receive. Ideas and comments may not appear immediately. Some legitimate ideas are flagged as spam and will be added when we review the spam folders.
Content: This portal is for product ideas and feedback only. If you need customer service assistance, contact your Acumatica Support Partner, submit a support case, or get assistance from community resources: LinkedIn Group or StackOverflow
No Reliance: Information is maintained on a best-efforts basis and may be changed without notice. Acumatica cannot guarantee the accuracy of the information provided or guarantee completion of features/ideas described on this portal.

Enable support for OData and Google Spreadsheets

With the new version of Google Spreadsheets the ability to import OData is available using the =importfeed(url) formula.  Many companies leverage Google Documents as a collaborative worksite or use Google Documents in lieu of using MS Office applications.  The ability to import into Google Spreadsheets would be beneficial.

  • Rick Van Doel
  • Jan 5 2016
  • Rejected
  • Attach files
  • Vladimir Panchenko commented
    June 22, 2018 14:34

    Unfortunately, IMPORTFEED function in Google Spreadsheets doesn't support any kind of authentication.

    You can read more about it in the official documentation and here on StackExchange.

  • Don Hardaway commented
    August 31, 2017 15:31

    Supposedly, Google and SAP are working to connect Google sheets to SAP HANA. It would seem pretty simple for Google to provide an OData connect like Excel has.  Get moving Google!!

  • Michael Pratt commented
    January 20, 2017 20:34

    I think that this is still something that would be beneficial. We export our orders to google spreadsheets and for Acumatica to be able to automatically import those new orders, would be awesome. 

  • Gabriel Michaud commented
    January 05, 2016 13:43

    Thanks for your suggestion. I tried it myself and it seems that passing credentials from the URL via the standard username:password@host format doesn't work. We'll review and see if we can come up with a workaround.