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.
Hey @Swift_Struck_24 @Jeff_Hager thanks for the info, it’s made me think a bit about how I’ve structured things with my company and Glide. We’re a really small low-code team startup, and the way we’ve been building is having one Teamspace that houses multiple clients because our app is based on a single template, and all client apps are variants of this with subtle changes depending on the client’s needs. Our client base is rapidly expanding based on the success of this app idea, so, as you can imagine, updates are a hiccup in planning (but that’s another problem for another day). When I started with Glide I played around with sheets but decided to stick with internal tables as much as possible. Our app uses MAKE.com heavily, and with their new pricing plan and Glides’ inability to add data rows or updates via MAKE in a single dump, the growth we’re seeing is going to start to really affect our MAKE $$ cost for one function, so a daily dump to a sheet would be ideal. I thought I would start fresh, create a new Google account and go from there, but from what you say, my whole business on glide is locked to that one gmail account that I sigend up with years ago, I’m worried now how I secure my business based around that email, what is something goes awry with that address does that put my account and hence clients in jeopardy? Sorry if this sounds completely naive and silly planning, it’s just something I’ve never thought about
I don’t have exact answers for you, but you may want to check this out. I’m pretty sure you can disconnect a google sheet and connect to a different one, but aim not sure off the top of my head if you can connect to a sheet on a different google account altogether.
Thanks @Jeff_Hager yeah, it’s one of those things that when I signed up for glide, it was a test to see if it would suit, which it absolutely did, and then it started to grow, and now it’s freight training and I’m starting to panic about things I never thought about starting out. You kinda don’t know until you know what you now know . I’m sure back in the day, you used to be able to connect and disconnect. I look at my Gdrives. They are all filled with test databases, but now I just can’t find a way and then the thought of ‘Your business is completely tied to this one stupid email account you used to test products out’ is scaring me !