Automating your business? Use my tools and help make more!

[JTPets]

I have recently started using AI to automate my business - I am seeking like minded folks to contribute to code and code ideas with AI in the last few weeiks I have created code that:

1: Google Apps Script that exports the Square catalog via API to google sheets

2: Google Apps Script that takes a workbook and copies it to another workbook automatically on a timer

3:Google Apps Script that auto updates Google Merchant Center listings, auto refresh a catalog google sheet in Google Merchant center & creates a TSV file in your google drive automatically with local inventory

All of these have been released publically on my GitHub, all of them come with set up triggers so no values are hard coded, all of them are released for free under MIT licence.

As a result of these 3 pieces of code and a few extra google sheets formulas, every morning I have a spreadsheet updated with with my catalog, a list of items to audit for missing descriptions, or missing UPC, or negative inventory. By combining this extraction data and a manual catalog export I even have a order generation tool now by vendor (similar to the auto purchase order tool square disappeared without any comments)

These are all features I believe should be native to Square however until they start to address these gaps let's work together to build open source tools for each other...I can't code and I've got 3 new pieces of code to automate my business....

How are you automating yours?

Check out my github for the snippets of code I am using in my signature

[maxpete]

Thank you for always looking out for ways to support other Sellers!

[Candlestore]

@JTPets ;

Is there a list of what APIs pull from Square?

You are using an API to pull catalog in your above example.

Is there an API that could pull Squares Gross Sales. Taxes, Fees and show daily Deposits?

I was just watching this Video about how to write Google Formulas that can be similar to Excels Power Query.

Google Sheets Query Video 

I was thinking if I knew which API pulled the above data we could write something that could Group the Deposit IDs together to show people what went into each deposit to balance Checkbooks easily.  I was thinking of this because I see alot of Questions in the forum about finding the Deposited amount easily and questions Why the Deposit does not match their expectations.  

Currently I do this downloading my Transacations for a month as a CSV file then have A pivot table by  Date and grouped by Transaction Day, which shows 2 deposits on a Monday for example because of the Weekend.  This also works for holidays.

This works but it has me Downloading the CSVs from Square, Deleting previous download of these files from a Square Folder, then moving the Newly Downloaded CSV to this Square Folder.  Then I have to open my Excel File with the Power Query and tap Refresh All.   Now power query gets the CSV files from the location Specified on my computer, manipulates the data, then returns results to the current workbook.   This save me alot of time but it still a lot of manual Downloading and moving of files.  This would be great to use Google sheets to pull this data using an API, and spitting out the final result without having to keep downloading the same csv daily, weekly or monthly.   

Just an Idea..... I know very little on computer programing and APIs that can be run in Square.

Any idea where I can get a list of what data and APIs you can get from Square?

[JTPets]

Start here to figure out which objects you are looking for happy to collaborate on this as I find time. But if you are using AI at all, the api has several different url's for different permissions, payments, catalog, etc, once we know what objects we are looking for I dump a bunch of the example documentation into a giant paste into the AI

I want you to make an api call to let me dump my catalog i got a connection error
Me: "I got error code "blah blah blah" the code you generated didnt work does this help "API Documentation page copy and pasted on api connections"
AI: "Oh I see my mistake you are operating in a live environment, i used a sandbox url...."

back and forth a few times, trial and error, little progress at a time

[JTPets]

@Candlestore I forgot the URL https://developer.squareup.com/reference/square/objects#object-index-T

[Candlestore]

@JTPets :

Thanks no when I have time I can slowly look through these API's to find which ones pull the Sales, Sales Taxes, and Square Fees and see what can be accomplished.  Still gota work on my AI questioning to get the correct answers I seek but its a learning process :).  Do you have an AI that you prefer?  

[JTPets]

I use chatgpt mostly with a paid subscription for the newest models.

[Candlestore]

@JTPets ;

This may become addicting!!!

I went to a ChatGPT site, asked a simple question, then expanded and expanded.  Asked to create a Google sheet that could be used to automatically get Transaction Data from Square, Then asked for some specific lines and then asked about Daily, weekly and Monthly toatals as a running total with some sample data.  Poof there were lines of code and even sample data to see visually what the Google sheet would look like.  Then I asked if instead of using google could it write code to do this with Excel inside Microsoft 360.

Sure thing this can be done in Excel Microsoft 360 here is what needs to be done ..... 

This is what I got for a Sample from AI for Excel:

I know with Google Storage you get 10 or 15 GB but in my Office 360 I get 1TB of storage which might be the way to go and then have Chat GPT show me how to create Business Dashboards in Excel that are interactive.  

Now I did notice Math errors in the Sample data because if you add the Net deposit plus Discount plus Processing Fee and adding the tax, that number still does not add up to the Amount.  So some tweaks as you pointed out might be needed but its one great starting point.

The below Image would be something that I would love to create using ChatGPT with my Square Data that is automatically renewed ever morning 30 minutes before my alarm goes off.  Then when I get in I can see where everything is and maybe have a few different charts showing my calculated deposit that I should see from Square.

This is something Square should have for Reports instead of all the seperate little reports.  I hated Programming which is why I went into computer networking before, now I am using ChatGpt to program..... I can't get away   LOL.  

I just saved the Web page to a folder on my computer so I can look at it later when I have time.  Thanks again for showing the power of ChatGpt to help be able to write codes to get the information and maybe even build a Dashboard like above.

[JTPets]

So the cool thing I did with my code is I am desigining it to run without Ui Calls so it can run headless on a timer, and I am also not hardcoding any variables so it can be released publically and used easily - It also prevents you accidentially leaking an API key!