1
1 Comment

Building a Sales Lead Canvassing App - Google Sheets + DronaHQ

  1. 1

    Google Sheets is among the most popular data storage solutions and for good reason – forever free and unlimited storage, cloud-based, and a short learning curve. It is where most internal tools begin.

    However, challenges start to surface when it comes to user based to access controls, business rules and validation.

    In the example, we have a Google Sheet with sales leads, their contact details, some notes, and the names of sales rep the lead is assigned to.

    In order to allow sales rep to only see leads assigned to them, and update lead information - such as notes, next steps, update contact details, and so on - we create an admin panel that lists the leads from the sheet onto the app and based on the user that is logged in, it filters the leads displayed.

    How are you solving these Google Sheet challenges in your organization? Let me know in the comments

Trending on Indie Hackers
How I grew a side project to 100k Unique Visitors in 7 days with 0 audience 49 comments Competing with Product Hunt: a month later 33 comments Why do you hate marketing? 29 comments My Top 20 Free Tools That I Use Everyday as an Indie Hacker 16 comments $15k revenues in <4 months as a solopreneur 14 comments Use Your Product 13 comments