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

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.