Automatically Export Reports from Lightspeed Retail POS

rishirishi Member Posts: 24

Is there a workaround to automatically export reports from lightspeed retail pos? Perhaps via the API??

At the moment I do not have a need for Lightspeed Analytics, but simply being able to automatically fetch the export CSV's would be very helpful.

I'd like to have them upload directly into Google Sheets.

I know each export button in lightspeed has its own url, which if you go to directly and you're already authenticated in lightspeed, it will download the file directly. Can this be utilized somehow?

One option I'm thinking is to create a macro, but before I do this, I'm wondering if there's a better way.

1 comment

  • Adrian SamuelAdrian Samuel Moderator, Lightspeed Staff Posts: 625 moderator

    Hey @rishi,

    The API would be the best way about doing this!

    Here's a link to our documentation

    Were you successful in this endeavour?

    Adrian Samuel

    Integrations & Solutions Developer - Strategic Solutions

    Lightspeed HQ

Sign In or Register to comment.