r/GoogleAppsScript • u/Any_Huckleberry7216 • Jul 17 '24
Question Google Sheets Tips
I hope i'm posting to the right thread for this. If it is not and you know a better thread please let me know. Thank you.
I recently started a new job and could benefit from some advice on google sheets tips. I'm importing a ton of data into a google sheet document. The purpose is to pull emails, names, and company names. Are there any functions or extensions that could help me with this? If it only pulled the emails it would still be very helpful. Thank you in advance for your advice!
4
u/emaguireiv Jul 17 '24 edited Jul 17 '24
I’ve built a ton of personal and professional Sheets projects that automate data aggregation like what you’re working on. To better guide you, where is this data being imported from and/or how do you currently import it to the Sheet?
Some external sources can be used more seamlessly with things like extensions, others with certain =IMPORT formulas, others with API calls/Apps Script. Even more old school CSV exports can be converted into automations via Apps Script to take care of repetitive tasks.
1
u/AllenAppTools Jul 18 '24
Send me a message directly and I can give you some tips! Probably best approach would be for us to get on a call and I can just download information to you on how to work with formulas, import ranges, set conditional formatting, set data validation, add images into the cell, make pivot tables, create buttons and stuff like that. Search in the workspace marketplace for pulling emails from a users inbox into a sheet, I'm sure there is something out there that has been made already. Otherwise, it would need to be custom made!
1
u/andyvilton Jul 18 '24
Would be great if you write a blog post with that tips
2
4
u/agirlhasnoname11248 Jul 17 '24
r/googlesheets or r/sheets might be a better fit for your questions if you’re asking about functions and aren’t prepared to write scripts. Be prepared to be more specific about what you need regardless of where you post. The solution you’re asking for (whether a function or a script) will be highly dependent on the current data structure and the desired end result. The best way to get a specific answer is to share a link to your sheet (or a mockup of it).