AutoSheets needs you to sign in

[Duckredbeard]

I have a AutoSheets task that runs every 10 minutes and I'm getting this notification, but the sheet is still getting its update (sometimes after a one minute delay).  Check this crosspost from Reddit for a screen shot..

https://www.reddit.com/r/tasker/comments/mzr8f8/autosheets_sign_in_notification/

[Matevz Leskovsek]

I dont have this problem (it updates in realtime and without any
prompts), maybe because I have Google Sheets app installed on the same
android device?

On Wed, Apr 28, 2021 at 1:27 PM Duckredbeard <duckre...@gmail.com> wrote:
>
> I have a AutoSheets task that runs every 10 minutes and I'm getting this notification, but the sheet is still getting its update (sometimes after a one minute delay). Check this crosspost from Reddit for a screen shot..
>
> https://www.reddit.com/r/tasker/comments/mzr8f8/autosheets_sign_in_notification/
>

> --
> You received this message because you are subscribed to the Google Groups "Tasker" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to tasker+un...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/tasker/0b356471-2873-4927-b738-92ce6ad06584n%40googlegroups.com.

[Duckredbeard]

I also have Google Sheets installed on this device.  Had this a few times overnight and the sheet was not updated on those tasks, but other updates happened.  So it doesn't happen on every event.  Forced stop and cleared cache.  Let's see if that does anything to help.

[João Dias]

Hhmm, is it possible that your phone didn't have an internet connection at the time that happened?

Thank you for your contact.

   Join: connect multiple devices (send pushes, remote SMS, notifications) on Android, Windows, Mac, Linux

   Tasker: customize/automate anything on your phone!

   AutoApps: add advanced functionality to Tasker via plugins

     

João Dias

[Duckredbeard]

My AutoSheets task is triggered by an incoming AutoRemote message, so I have internet connection!  I installed the one you sent me in the email and have not had any more of the notifications, but I have had one anomaly in the last 36 hours where one task fired 5 minutes late.  Not sure if it was because of a delay in getting the AutoRemote event or if it was the AutoSheets update running late.  

The issue seems to be resolved, but can't say for sure for another 48 hours.

Thanks for your continued support and development!

[Duckredbeard]

Still seeing it miss one or two entries per day, but those notifications are gone.  I expect the message is going out because the python script has a local .txt update on the next few lines and that is happening.  I corrupted the device ID to see if it would error, but it didn't.  It made it through those lines so it doesn't care if the url is bogus.

I have to find a way to capture whether it is the message not being received or the sheet update not sending.  Since this is expected about every 10 minutes, I guess I could set some sort of timer to start upon receipt, then create a notification if more than 11 mins pass without getting the next one.  Theory would be that if I don't get the notification, then the sheet should be updated...

[João Dias]

Maybe you can do a local log on your phone every time you get an AutoRemote message and compare that with the sheet writes?

[Duckredbeard]

I found a "runlog.txt.1" file in my local device and I have taken a screen shot.  It shows that the AutoRemote message was received, but the AutoSheets update did not process at 650 am today.  I placed a red line where the 650 update should have happened in the GSheet.  Check the attached screenshots.  If the screenshots are not clear, let me know.

https://photos.app.goo.gl/nKDWZQ7GRXgsvmrn9

[Duckredbeard]

This log helped me realize that I had a "Perform Task: Color Keg 1" action to happen twice in that task.  Corrected to run only once.  This should not contribute to the error, as this is intermittant.

[Duckredbeard]

I have added a "Variable add" to my task and added that variable to the data to write to the sheets.  This gives each line its own unique number.  Now I will have Tasker check the cell F3 for the newest variable value.  If it is not the newest, then run the update task again.  This will be a backup plan to post the data if it is not current.

[Duckredbeard]

Here is the task that takes the variable %KegData whose value is "KegData|13.59|328891.0|65.42|37.04|11.48" and breaks it up to what I need.  From this, I use a few of the split out variables to send to the sheet.  In a recent "failure" I see the increment of column F, which is the variable %KDCOUNT, but what is odd is that it skipped a time entry at 13:50.  My theory was going to be that if that entry was missed, there would be a gap in column F!

If column F got incremented and then sent to the spreadsheet with the other data, why did the other data not also get brought in?

  KegData (624)

    A1: Variable Set [ Name:%KegData To:%armessage Recurse Variables:Off Do Maths:Off Append:Off Max Rounding Digits:3 Structure Output:On ] 

    A2: Variable Split [ Name:%KegData Splitter:| Delete Base:Off Regex:Off ] 

    A3: Run Shell [ Command:date +"%H:%M" Timeout (Seconds):0 Use Root:Off Store Output In:%KEGDATATIME Store Errors In: Store Result In: ] 

    A4: Minimalistic Text [ Configuration:%KEGDATATIME = %KEGDATATIME Timeout (Seconds):0 Structure Output:On ] 

    A5: Minimalistic Text [ Configuration:%KegData1 = %KegData1 Timeout (Seconds):0 Structure Output:On ] 

    A6: Minimalistic Text [ Configuration:%KegData2 = %KegData2 Timeout (Seconds):0 Structure Output:On ] 

    A7: Minimalistic Text [ Configuration:%KegData3 = %KegData3 Timeout (Seconds):0 Structure Output:On ] 

    A8: Minimalistic Text [ Configuration:%KegData4 = %KegData4 Timeout (Seconds):0 Structure Output:On ] 

    A9: Minimalistic Text [ Configuration:%KegData5 = %KegData5 Timeout (Seconds):0 Structure Output:On ] 

    A10: Minimalistic Text [ Configuration:%KegData6 = %KegData6 Timeout (Seconds):0 Structure Output:On ] 

    A11: Run Shell [ Command:date +"%m/%d" Timeout (Seconds):0 Use Root:Off Store Output In:%KEGDATADATE Store Errors In: Store Result In: ] 

    A12: Variable Add [ Name:%KDCOUNT Value:1 Wrap Around:0 ] 

    A13: Perform Task [ Name:Color Keg 1 Priority:%priority Parameter 1 (%par1): Parameter 2 (%par2): Return Value Variable: Stop:Off Local Variable Passthrough:Off Limit Passthrough To: Reset Return Variable:Off Allow Overwrite Variables:Off Structure Output:On ] 

    A14: AutoSheets Add Rows [ Configuration:Spreadsheet ID: SuperSecretSheetIDRGjHamu8uNDOBeNcQ

    Sheet Name: Keg

    Data: %KEGDATADATE,%KEGDATATIME,%KegData4,%KegData5,%KegData2,%KDCOUNT

    Separator: ,

    Row Separator: 

    

    Mode: Parsed

    Cell Reference: A3 Timeout (Seconds):60 Structure Output:On Continue Task After Error:On ] 

[Duckredbeard]

Screenshot of recent fail...https://photos.app.goo.gl/H5UhBqvFA7VJ2y3v9

[João Dias]

Hhmm have you tried enabling the Offline option in the action? Maybe that helps?