When I try to create the Google spreadsheet with my transactions it does not work. I am taken to the page again, confirm 3 times which creates 3 sheets on my Google drive but they are all empty. I have chosen to upload all past and future transactions.
When I did it, it took about half an hour for the spreadsheet to start populating, and then took another half hour to fully populate. My app didnāt show as active until it had fully populated.
Do not move, rename or manipulate the file in your drive until it has done. Once itās finished, you can move to a dedicated folder if you want but do NOT rename the file or tabs.
I would also advise you do any dashboard/data analysis in a separate file, using the āIMPORTRANGEā function. This way, if you have to re-enable the googel sheet export for any reason, you only have to change your āIMPORTRANGEā formula to find the new file instead of copying everything into the new file/sheet.