I am currently evaluating Spreadsheet.com for my company, and liking what I see. Currently I am trying to understand how we might use it for our initial use case. In order for your product to replace our current workflow, we need to build a CRM with tasks. I’ve been looking at your Simple CRM starter and it’s mostly there, but need some guidance on how you think we should tie tasks to each opportunity.
Basically we have several tasks we need to track tied to each opportunity. For example, when I create an opportunity I would need to track outreach tasks such as emailing them, setting up meetings, etc. As the opportunity passes through various phases, then new tasks would be created and assigned, such as creating and revising proposals, etc. There are multiple team members that would be assign to various tasks. Ideally tasks would be synced to Google Calendar.
My question is: How do you recommend setting up a system like this? Use a separate sheet for tracking tasks? If so, could you create a task from the Opportunities sheet? I know we could use automations for creating some canned tasks, but many we would need to create manually. Or would we manage the opportunities status from the tasks sheet?