This guide will show you all the necessary steps to transfer your Supermetrics for Google Sheets queries to another user, so they can continue to run them with minimal interruption. This guide assumes the current file owner and license holder is still available to assist with the transfer - if they are not, see the Common Issues section for further guidance.
Step #1 - License Access
Verify the new user has a valid Google Sheets license for their Google email account, so they can continue to run the queries.
If you need to transfer license ownership as well, see the standard license change instructions for Google Sheets. If you are unable to follow these instructions, then see the Common Issues section below.
Step #2 - Data Source Platform Access
Make sure the new user has access to the data source platforms themselves (rights to see property in Google Analytics, access to Ad Account in Facebook, etc.) or can use a general user account, so they can set up the data sources under their own accounts.
Step #3 - Transferring the Queries from one file to another
- Open a new Goole Sheet file which you want to transfer the queries to
- From the new Sheet, launch the Supermetrics sidebar and log into each data source that applies to the queries to be transferred. This step is required so the permissions for this user are set for the next steps. See also: Logging into Data Sources for Google Sheets
- From both Sheet files, open the SupermetricsQueries tab (if hidden, click Add-ons->Supermetrics->Manage queries).
- From the old Sheet, select, copy the whole row of the query, and paste it to the new file
5. After pasting the row to the new sheet, delete the following values in that query's row in the new sheet:
- The "query ID" (column A)
- The "Refresh with user account" (column AU)
- Once all the queries have been prepared, click Add-ons->Supermetrics->Refresh all to update the queries for the new user account and their data source access.
- You can see that, after refreshing, there will be a new "Query ID" assigned to the cell. so please verify each query has a new "query ID" value and a new "refresh with user account" value.
- Repeat steps 2-6 for the rest of the queries on the list and additional files (if needed)
Issue: Query failed - can't get range for query Spreadsheet ID xxx. Maybe the sheet has been deleted?
This issue happens commonly when transferring queries from an old Sheet file to a new one. It is because the new query could not yet recognize the range for the new data to be written on. (see error message in screenshot)
To fix this, just simply delete the values in Sheet name (Column E) and Range address (Column D)
Type the name of the sheet you want your query to be in. In this example, we want our data to be written in Sheet1 so Sheet1 is typed into Sheet name
After that, click Add-ons->Supermetrics->Refresh all.
After refreshing, the data will be written at the exact same location where it was in your old sheet.
Step #4 - Transfer Triggers
- The new user should log in with their Google account and open the Sheets file where the trigger is located.
- Open the Supermetrics sidebar and go to the Schedule tab.
- Hover your mouse over the icon next to the trigger you want to transfer. You will see the trigger's current owner, and you can click on Transfer to me to transfer the trigger ownership to your current user account.
Step #5 - Transfer File Ownership (Optional but Recommended)
If the original file owner will no longer be using the file or the Supermetrics product, it is recommended that the file ownership be transfered to the new account so that all features (mainly triggers) have enough rights to run properly. See this guide for how to do this in Drive: https://support.google.com/drive/answer/2494892?co=GENIE.Platform%3DDesktop&hl=en
I'm Unable to Transfer the License/Cannot Access Team Management
This often happens when the original license holder account is no longer available to help with the transfer and the new users are "locked out".
Support can help get you access again. Please submit a new Support Request that includes:
- The original account ID, so we know which license
- Either the buyer email or invoice ID so we can confirm rights to the license
- And which Google account you want to be given Owner rights to so they can log in and continue the transfer
I'm Unable to Change Ownership of the Files
If the original file owner is no longer available, it may be impossible to transfer the ownership of the files. To work around this, you can duplicate the file (click Add-ons->Supermetrics->Duplicate this file for another account), or copy the query configurations from the SupermetricsQueries tab into a new file's version of that tab (you need to open the sidebar at least once to enable the creation of that tab).
I Might Have Orphaned Triggers I Cannot Remove
If the original license holder is gone and cannot remove their triggers from the file, you can make a duplicate of the file (which won't carry the triggers) with Add-ons->Supermetrics->Duplicate this file for another account. Then delete the original file and empty the trash to remove their triggers completely.
If you believe you have a lot of triggers from the older user and it would take too long to remove them manually, please submit a new Support Request that includes the email of the original user so we can find and programmatically remove the triggers.