Skip to main content
All CollectionsErrors and troubleshooting stepsMeta rules
My sheet is active but I see this error in the logs “Google Sheet file was deleted or access to it was lost”
My sheet is active but I see this error in the logs “Google Sheet file was deleted or access to it was lost”
Sara avatar
Written by Sara
Updated over a month ago

This error means there is something off with the access to the Google Sheet used in the custom metric within the rule.

1) Please go open the Google Sheet used for your custom metric within the rule, and open its sharing settings. Make sure the access is set as "Anyone with the link":
​

2) Go to Automate -> Custom metrics. Open the custom metric used in the rule -> Google Sheets:
​


Click the gear button as on the screenshot below, copy and paste the link from the Google Sheet, click Add -> Save changes

3) Once you have reconnected the Google Sheet to the custom metric used in the rule, wait for the next check of the rule. Given that the access issues have been fixed, the error should disappear from the logs during the next сheck.

If the issue persists after completing all the steps above, please reach out to us at support@bir.ch

Did this answer your question?