Question

How do I import all Square sales transactions to Google Sheets once a day?

  • 10 October 2023
  • 5 replies
  • 26 views

Hi there, pretty new to Zapier and have created a few simple zapps, but want to create a more complex one and not sure if it's possible. I want to import all sales transactions for the day from square to a google sheet once a day instead of when a transaction occurs. If I did a zap for every transaction it wouldn't've be worth it since we have about a thousand transactions a day. 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Userlevel 1
Badge +1

If you want to do this with Zapier, it does not matter if you do it on every transaction or once a day. It will use the same amount of tasks. This can also be done with a quick RPA automation, which keeps the cost lower.

What RPA automation would you recommend for something like this?

Userlevel 1
Badge +1

What RPA automation would you recommend for something like this?

Do you have any coding knowledge?

 

Some

Userlevel 1
Badge +1

I like to use Robocorp. They also have their no-code tool called Automation Studio that helps alot. It utilizes Robot Framework which is python based language. You can also use native Python to write the automations. Have a check and see!