I have the Google Drive pack installed and have made a button to refresh the table and log a timestamp when this done.
I have set the pack to refresh manually but set a time based automation to click the refresh button referred to above. This seems to be the only way to get a timestamp of the last refresh.
The automation works great when tested but throws this error when trying to to a time based trigger: “TriggerSync can not be run in automations”
I’m not sure about what I’m going to say but did you check “who” runs the automation ?
(in the Take actions as dropdown menu at the bottom of the automation)
The automation bot can’t use Private pack accounts, so maybe that could be where the issue comes from …