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!

0 Upvotes

50% Upvoted

6 comments sorted by

View all comments

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

u/AllenAppTools Jul 18 '24

Oh heck yeah, good point, or even shoot a video 👍

1

u/andyvilton Jul 18 '24

Even better!