We're landlords and we're building an AI chatbot for tenant maintenance issues. Many of them they tenant can fix themselves, and when this happens, the chatbot will talk them through it and report the results to a trello board. When it remains unfixed however, teh bot will still report it to Trello and we're looking to see what automation can be done. Ideally we would like to be able to assign it to an appropriate tradesman and have that automatically send an email to them with issue and desired date - we would then like the trademan to be able to confirm/set a date and accept the job. This would change the status to accepted and we would like that to trigger an email to the tenants of that house to let them know it is being done. Is this possible with teh powerups and automations? There seem like lots of optons and I don't know what would be best. We'd like the tenant email addresses to be held or upload from a google sheet or similar - trello would need to be able to identify the right people from the house (whidch we currently simply flag with a label. All suggestions appreciated.
