Skip to main content
Question

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


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. 

Did this topic help you find an answer to your question?
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

Santeri
Forum|alt.badge.img+1
  • Beginner
  • 27 replies
  • October 10, 2023

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.


  • Author
  • Beginner
  • 6 replies
  • October 10, 2023

What RPA automation would you recommend for something like this?


Santeri
Forum|alt.badge.img+1
  • Beginner
  • 27 replies
  • October 10, 2023
jsestby wrote:

What RPA automation would you recommend for something like this?

Do you have any coding knowledge?

 


  • Author
  • Beginner
  • 6 replies
  • October 10, 2023

Some


Santeri
Forum|alt.badge.img+1
  • Beginner
  • 27 replies
  • October 10, 2023

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!