Loyverse sales analysis by Make & ChatGPT (OpenAI)

[Yasuaki]

Hello!

I would like to share that we created a Make.com blueprint to analyze business data from Loyverse.
This template aggregates daily sales from Loyverse every day on Google Sheets. At the end of every month, ChatGPT will read the accumulated data from the Sheets and give you suggestions to improve your business performance.

DOWNLOAD BLUEPRINT

1. To use this blueprint, please log in to Make.com and create a new scenario.

2. Download the blueprint from HERE and import it.

3. Log in to Google and Loyverse on each action.

4. Create one Google Sheet and name the first sheet “Sales by Date”.

5. Connect the sheet in 4. to Make workflow.

6. Create an OpenAI account and generate a ChatGPT API key here.

7. Add the API key to the OpenAI action in Make.

8. Specify your email address where you want to receive suggestions from ChatGPT.

9. Schedule the scenario every day after your shop is closed.

10. Click "Save".

Then, wait to receive an email at the end of the month.

After receiving an email, please create a new sheet and connect it to the scenario (4. and 5.) to refresh the data.

Looking forward to your feedback if GPT's suggestion is useful or not

DOWNLOAD BLUEPRINT

[Yasuaki]

For Loyverse users who have less than 250 receipts per month (or per week), a simpler version of Chat GPT integration is available.

1. Start by downloading the blueprint from HERE. Then create a scenario on Make.com.
 
2. Import the Blueprint by clicking on the 3-dotted button on the lower part of the Scenario.  

3. Log into each bubble that has Google Sheets and Loyverse icons.  

4. Create an OpenAI account and generate the API key there.   

5. Copy the API key and paste it to the “Connections” part on the ChatGPT bubble in Make.  

6. Don’t forget to change the email to the preferred email to send the AI prompt to.  

7. Schedule the scenario to the last days of the month and set the time to whatever time it is preferred to have the scenario start.  

8. Save the scenario and it is now good to go!

With the advancement of AI this time around, it is crucial for businesses to catch up to it and utilise such advancement to the fullest potential in assisting the growth and economy of the business and take advantage of it.