Your Business Growth Agency

I need a custom CRM web app and database

By Rich Peterson
In 🌅 Now
1 Min read
I

Further question details

We currently manage large customer and prospect lists in multiple Google Sheets and Excel. We want to migrate this into a cloud database.

We do not current have a database setup, so we will need to create one based on an example customer list and handle migration of our lists into the database.

We will need a web user interface to perform create/read/update/delete operations on these contacts, as well as query them by such things as address and business type.

The solution should be cloud based so that we don’t need to have our own servers, preferably in Google Cloud or Amazon AWS.

Answer

There are quite a few options for you in migrating your Google Sheets and Excel sheets into an online database program.

I’d recommend that you look at Airtable, Coda, Podio and Trello.

For your multi-faceted search of the database, business categories & quick import of .csv or .xls files, you’ll find Podio a useful solution.

About the author

Rich Peterson

I've spent the last 10 years planning, mapping & reimagining the processes of hundreds of SMBs. Whether the goal is more money, more time, more clarity or more customer smiles, my insightful process is worth every minute for my successful clients.
-----------
Disclaimer: I use affiliate links on my website and only recommend what I use, have used or have vetted in the best interest of my readers. I may earn a commission if you click on an affiliate link, but it won’t cost you extra.

View all posts

Read more

Podio app development

By Rich Peterson
In 🤔 Advice
10 Min read
P

Question: We need Podio app development advice and development help. See the details below. Strategy Use Podio as main tracking system for all builds from lot lead tracking and purchase to final inspections, leveraging automation to increase effectiveness. Tactics Develop an all-inclusive Podio experience with multiple workspaces, apps and automations that build off of existing infrastructure to...

Read onRead later

Setting up Processes with ClickUP, Airtable and Zapier

By Rich Peterson
In 🤔 Advice
1 Min read
S

Question: We would love your support to setup our Recruitment Agency and Consulting Firm’s Automation Workflow using ClickUP, Airtable, Google Suite , Slack, Typeform, Harvest, Google Calendar, Zoom, Calendly and Zapier. We are looking to develop databases, with the potential to link them to our website in the future. We hope to automate and integrate all the workflow processes to ensure...

Read onRead later

Microbakery Workflow

By Rich Peterson
In 🤔 Advice, 🎬 Workflow
4 Min read
M

There’s an overused quote about building a better mousetrap leading to people knocking down your door that applies to a microbakery in my area. A gravel driveway leads you past building materials to a little green shed, oh, and a long line of people waiting to buy bread & pastries. They make amazing products but by informally speaking to customers, staff and the owner, there are some...

Read onRead later

Basecamp for Digital Media Remote Agency?

By Rich Peterson
In 🤔 Advice
2 Min read
B

Further Details: We are a boutique digital media (fully remote) agency looking for help with knowing if Basecamp3 is the best choice for our digital media agency. We’ve switched from Asana to Trello to Basecamp and are lacking recurring features (which is driving us crazy) as well as quick templates for completing tasks. We’re tired of switching software and really need a recurring...

Read onRead later
Your Business Growth Agency