Reading Taifun's documentation, if it says tinyDB, it probably means only the TinyDB. The only way you can get data outside of the app in real time is using his email and MySql examples (or using another api that allows POST). You can get coordinate history while the app sleeps using the TinyDB when the app is no longer sleeping.
Suggest you learn from Taifun's example app 1. Follow the opt-in URL for the locationservice example app to get access to the app and to be able to download it to your device. Here you can test all the features.
If you followed all the advice correctly, all the coordinates found by the extension are posted to the spreadsheet. The last coordinate posted (most recent post) is the current location.
What does not work?
did you make the Google Spreadsheet?
did you provide the link to the spreadsheet in the url in the Blocks?
is the app posting data to the spreadsheet?
what does work?
Can you provided the shared link to your Google Sheet here? Perhaps someone can look at your project and provide specific advice?
Did you open up the script editor and paste in the script shown in Tim's tutorial?
Did you save and then publish your script as a web app, with the web app executed as you (your google account, same owner as the sheet), and accessible by anyone (with 'even anonymous' if using the legacy script editor)?
If you did all these things, you should have created the required Google Sheet. Something is wrong. What does your Google Sheet look like? When you display the sheet on your Google Drive, it will look like something like:
Copy the url you see. You should be able to paste it into an new window in your browser and see your sheet. If you post that link to your spreadsheet here in the forum, I will look at it for issues and might be able to help.
Your script is not connecting because you have missed a step in creating the link or you are not using the correct url in your app Blocks. Google provides two links to the spread sheet when you create a script. The correct url needed in the app is the script link; The script url will look something like
What do you want to put? Do you want to show the link to your spreadsheet here? Just copy the link and drag and drop it in this box.
You might want to answer using your own language if English is not your primary language . Please explain in more detail.
To learn how to build and share a Google spreadsheet that uses a script, see Tim's example HOWTO: Create a Google Apps Script Web App bound to a Spreadsheet . Make the Project in that example to learn how to use the spreadsheet part of the real app you want to build. Then use the advice to build Trak_It.
If you wrote the required code to post your location to your spreadsheet using the LocationService extension, the script probably will go where indicated in this graphic
