Hi Gliders, I’m sure I’ve done this in the past, but I’m stumped. I have a business account, and created a new app from a template that I have stored in my Templates. I want to connect a Google sheet, so I add a new data source and it takes me to one that is currently connected. I want to change that to a new Google account, complete new login account, but I cant figure for the life of me how I do that, I’ve tried everything, thanks so much in advance
hi laurence, the easiest way to get a new spreadsheet as your data source is this:
- Open the spreadsheet in a new tab
- Share the spreadsheet with edit access to the google account you’re signed in with
- Reload the glide builder
- Attempt to connect a new spreadsheet
- This time, choose the sheet that you shared with your glide google account
- If the template is already coming in with a pre-connected sheet, then go to the app’s settings, data sources and then disconnect google sheet before connecting the sheet you want
hope this helps
Hey @Swift_Struck_24 thanks so much, so the master account is locked to your initial Sign-in account? I wasn’t sure and couldn’t remember how I used to do it in the past, I thoight you could have multiple Google accounts running, but that’s all good, now I know, thank you so much for the advice
@Laurence_Schuberth you’re right, the main glide account is locked-in with the email you sign in with.
happy to help
@Swift_Struck_24 Thanks so much for your help, out of interest, is changing the login email a tricky process ?
Changing the log in email for any user is slightly tricky..
to allow them to change their email, you will have to use the glide api to change emails in the user’s table or have some webhook workflow / manual trigger wokflow to target the user’s row and set column values with the new email, in the email column
after this the user must be prompted to log out and sign back in with their new email.
you must also keep in mind that if your tables use row owners on email, that could pose an issue.
we’re actually working on an email change workflow if you’re curious
@Swift_Struck_24 I think they meant changing the Glide account to a different google user to be able to connect a different google sheet to the app.
To that, I’d say it would be a whole lot easier to create a new Glide account and new team folder under that new account, then add the original account as a team member, and then use the original account to transfer the app to the new team. At least in theory I think that is how it should work. Not something I’ve ever tried.