Connect Google Drive to ChatGPT
1:09
Пікірлер
@SarahBear25
@SarahBear25 Күн бұрын
Very helpful!
@kaspartambur
@kaspartambur 7 күн бұрын
Is it possible to just push the button and no extra window opens, but it still playes the audio?
@PhilipF
@PhilipF 12 күн бұрын
Thank you! Google's own documentation was much less helpful than your video on find/replace within formulas.
@ReillyJordynsmom
@ReillyJordynsmom 14 күн бұрын
How do we view the cell size in Windows? I tried Shift+Ctrl+4 but nothing happened.
@rcexteriorcleaningservices6908
@rcexteriorcleaningservices6908 17 күн бұрын
Whats to stop someone just copying your work and giving it away or selling for themselves?
@GA-uv4hy
@GA-uv4hy 20 күн бұрын
this is NOT I N S I D E. This is just trash liunks. I can not see the thumbnail and the player. scam video
@sarahhill3773
@sarahhill3773 26 күн бұрын
You have changed my life with the app script checkbox trick!! 🎉 Going to update all my spreadsheets now 🙈
@johnchezy
@johnchezy 29 күн бұрын
Thank you! This is awesome
@LizDayShow
@LizDayShow Ай бұрын
Disappointed that your community is currently waitlisted ... would have loved to have this generator in my arsenal! :)
@JumpscareRodent
@JumpscareRodent Ай бұрын
Thank you
@shawnchristophermalig4339
@shawnchristophermalig4339 Ай бұрын
is there a way to reflect a value (text or number) in a specific cell from google sheet to google slides? without the document studio and google forms and also automatic via manual refresh?
@yogaFLIGHT
@yogaFLIGHT Ай бұрын
I asked Chatty advantages, and it came back: "Data Analysis: Google Sheets offers various tools for data analysis. You can use formulas, pivot tables, and charts to analyze your email data and gain insights." Whoa. Next level cool!!
@yogaFLIGHT
@yogaFLIGHT Ай бұрын
What's the advantage of this spreadsheet over reading the emails in gmail?
@spreadsheetables
@spreadsheetables Ай бұрын
@@yogaFLIGHT The main advantage is that a spreadsheet allows you to organize, filter, sort, and analyze your email data in ways that Gmail doesn’t offer. For example, you can: 👉 Quickly find emails from specific senders or containing specific keywords Track patterns in email frequency over time 👉 Export and share your email data with others 👉 Use the data to create visual reports or insights (think Customer Service Dashboard for example. You can have a VA label emails as they come in and as the emails get imported you can track if you responded, what needs attention, you can add charts and sort messages by category, a kan ban board to track any follow up needed, etc) This level of organization is ideal for people who need to manage emails for business purposes, follow up on leads, or keep track of communications more efficiently. It t can also be used to filter sales emails, and extract numbers so it can be filtered into a sales tracker automatically (without having to use zapier). I can list so many other product ideas that this can be used for 😊
@yogaFLIGHT
@yogaFLIGHT Ай бұрын
Will this try to import images and files into the spreadsheet as well? What if I export to sheet from years of data. Will that file be HUGE?? Really interested in trying this out!
@spreadsheetables
@spreadsheetables Ай бұрын
@@yogaFLIGHT great question! The script extracts text content (like email subject, sender, and body, etc) into the spreadsheet, not attachments or images. If you have a large number of emails over several years, the file size could still be significant, but it won’t include the actual attachments or images-just the text data. So this should help keep the sheet more manageable, though it may still grow large depending on the volume of emails.
@yogaFLIGHT
@yogaFLIGHT Ай бұрын
@@spreadsheetables Awesome, thank you :)
@Pink_1012
@Pink_1012 Ай бұрын
Thank you so much this solved all the problems I was having
@xMrLucas16
@xMrLucas16 Ай бұрын
Is it possible for me to use this sane script but instead of manually pasting the URL getting it from the spreadsheet itself?
@SimonFeay
@SimonFeay 2 ай бұрын
Mine doesn't give me an advanced option. It just says it's blocked.
@kevin-vantage
@kevin-vantage Ай бұрын
I am having this same issue in one of my Google accounts, but not others. Have not been able to find a solution.
@jillianrose1831
@jillianrose1831 2 ай бұрын
I just want to add that your membership is amazing, excellent value . Thank you!
@spreadsheetables
@spreadsheetables 2 ай бұрын
@@jillianrose1831 aweee you’re sweet! thank you for being part of our world❤️
@jillianrose1831
@jillianrose1831 2 ай бұрын
This is so helpful, thanks a million. I am going to see how to do this on a pc, I do not have a Mac.
@spreadsheetables
@spreadsheetables 2 ай бұрын
@@jillianrose1831 try Windows key + Shift + S
@StarrConsulting
@StarrConsulting 2 ай бұрын
I love this new tracker.
@samh9548
@samh9548 2 ай бұрын
Beautiful page. I like the concept. I am trying to build something similar for a "personal dashboard" but would like to have the files or websites open within the sheet instead of opening new tabs. Have you explored any options like this? So that the user does not have to leave the sheet, especially if you tend to use the same sites repeatedly?
@djmichi1257
@djmichi1257 2 ай бұрын
Thank you ❤
@DianaMayeDesigns
@DianaMayeDesigns 2 ай бұрын
I'm really looking forward to this summit. i can't wait...
@johnnakirk7365
@johnnakirk7365 2 ай бұрын
I got Adrienne's awesome Business Dashboard and I love it!
@kaajalnagindas4986
@kaajalnagindas4986 2 ай бұрын
Watching the replay. How do we get the bookmarks to be an icon only?
@DianaMayeDesigns
@DianaMayeDesigns 2 ай бұрын
In Google Chrome, when you save a bookmark, erase the title. You can save the bookmark to the toolbar and Google Chrome will replace the title with their favicon. hth
@Sky-yj8wx
@Sky-yj8wx 2 ай бұрын
How did you do the fireworks Melinda?!
@spreadsheetables
@spreadsheetables 2 ай бұрын
pretty sure it's a Chrome voice command thing when you say a keyword lol
@Sky-yj8wx
@Sky-yj8wx 2 ай бұрын
Is this spreadsheet mean for the end customer or the nail salon admin?
@spreadsheetables
@spreadsheetables 2 ай бұрын
the salon admin!
@justcourt5326
@justcourt5326 2 ай бұрын
Did not find this helpful. Can hardly see the actual formula and the screen is blurry.
@joseph1d697
@joseph1d697 2 ай бұрын
Exactly what I was looking for ! Merci !
@pedrov2604
@pedrov2604 2 ай бұрын
Hi. What if the cell thats edited is in a table and has a formula in it? I can get the extension to work by manually editing the cell, but I want the timestamp to appear when the value of the actual cell is changed due to formula reaction
@jazminekwon7831
@jazminekwon7831 2 ай бұрын
i couldn't find anything on how to do this so your video is sooo valuable!! love how easy you broke everything down, we appreciate it!
@usamahhilaby8415
@usamahhilaby8415 2 ай бұрын
woww nice template there.. can You share it for me please..
@Sky-yj8wx
@Sky-yj8wx 2 ай бұрын
Looks interesting!! Canada does our dates different
@ShaharGalnoor
@ShaharGalnoor 2 ай бұрын
great viD thank you! how do I make a calendar based only on Sundays, Thursdays & Wednesdays in a the month? 🙏🙏🙏
@jillianrose1831
@jillianrose1831 2 ай бұрын
Thanks a million.
@spreadsheetables
@spreadsheetables 2 ай бұрын
@@jillianrose1831 you’re very welcome!😊
@michellerichards2067
@michellerichards2067 2 ай бұрын
In google sheets I’m doing a self graded protein synthesis practice with different mutations. Any ideas for a bonus?
@ChrisHouk-z2t
@ChrisHouk-z2t 3 ай бұрын
function openLink(){ var url = "yoururl"; var htmlOutput = HtmlService.createHtmlOutput('<script>window.open("' + url + '");google.script.host.close();</script>'); SpreadsheetApp.getUi().showModalDialog(htmlOutput, "opening link"); }
@danimotherofchickens479
@danimotherofchickens479 3 ай бұрын
Helpful thanks
@VolcanoEarth
@VolcanoEarth 3 ай бұрын
Thanks for the tip. This is just what I was looking for.
@DianaMayeDesigns
@DianaMayeDesigns 3 ай бұрын
Poor Mel... Thank you for powering through. This was so useful... thank you so much! <3
@iRevCMD
@iRevCMD 3 ай бұрын
I LOVE them!
@manueldust2361
@manueldust2361 3 ай бұрын
You helped me a lot! Thanks
@spreadsheetables
@spreadsheetables 3 ай бұрын
@@manueldust2361 yay! You’re very welcome!
@mileszito24
@mileszito24 3 ай бұрын
i past her up!
@royal3161
@royal3161 3 ай бұрын
I dont know why but it keeps saying "VALUE". I did what u did but the True is not highlighting
@spreadsheetables
@spreadsheetables 3 ай бұрын
@@royal3161 it may be a character out of place. Put your formula in ChatGPT and ask it what’s wrong with your Google sheets formula ☺️
@royal3161
@royal3161 3 ай бұрын
@@spreadsheetables already fixed it 😅. Thanks for this video 😊
@spreadsheetables
@spreadsheetables 3 ай бұрын
@@royal3161 awesome! You’re very welcome😊
@gravesfamilycreationsllc3350
@gravesfamilycreationsllc3350 3 ай бұрын
This don't work I'm still getting clicks for irrelevant search terms. Like example I got 120 clicks and 0 sales from another shops name.
@spreadsheetables
@spreadsheetables 3 ай бұрын
@@gravesfamilycreationsllc3350 the search term will still show up even if you turn off (with the previous data) , but you will no longer be charged for the clicks that come from those search terms
@joeychen7165
@joeychen7165 3 ай бұрын
Thank you, just what I needed!
@StarrConsulting
@StarrConsulting 3 ай бұрын
Do you just create folders in Canva for your template banks and image banks?
@spreadsheetables
@spreadsheetables 3 ай бұрын
@@StarrConsulting no folders. We use one Canva document per each format, then link them in Google sheets. We found that creating folders in Canva didn’t do much for us😂 we need direct links for things.
@SavvyPlannerStudioCo
@SavvyPlannerStudioCo 3 ай бұрын
thannk youu !!!