Integrate your Google Sheet Data with Sturppy
Import revenue data directly from Google Sheets. A lot of tools can export data to Google Sheets, with this you can virtually connect any tool you already use to Sturppy.
1. Find your google sheet ID
We need the ID of the google sheet from which we will read the data. The connection is made with a read only scope, so you don't have to worry about us changing your data.
The ID is the long string that you can find in the url.
Make sure you don't include any " / " in the ID.
2. Pick your Date Format
Insert the format that you are using for the dates in the worksheet. Available formats are:
Don't worry about using "-" or "/" in your dates, it works either way. All the dates must use the same format.
You can have multiple worksheets in the same document, the one that we will be reading from, must be named Revenue.
Pay attention the the initial letter, it must be upper-case.
The worksheet is required to have the following columns (the order doesn't matter):
Again, the capitalization is important, all of the columns must be lower-case.
It is important that the data that is inside each column is already validated, since we won't be able to validate it for you.
- item_name: accepted values is text
- amount: accepted values are only number with or without decimals. Don't include any unit, like '$'
- type: accepted only 2 values recurring (for subscriptions) and one-time (for transactions)
- created: accepted values are only dates, don't include the time part.
- ended: accepted values are only dates, don't include the time part.
If you have problems with filling in the spreadsheet, you can download a sample sheet here.
Each row represent a subscription that is either active or inactive. Active subscriptions don't have the ended date, while inactive subscriptions have an ended date.
A row is not a single transaction. This means that if a customer has been subscribed for 10 months, you only have one row with the created date.
The amount is the price that the customers pays each month. If your export is in a different time-period (e.g. annuall), you need to change the values to reflect the monthly price.
When you connect for the first time, we check that your google sheet is correctly set up, so you know if you have anything to fix.
Automatic imports will fail if you change anything of the above.
Sometimes there may be an error that you can't find by yourself, in that case, please contact us via the in-app chat and we will be happy to help you.