Assistant AND google sheet consultation

#1

Hi everyone. I wanted to ask you if you think something like this is feasible. It would be a virtual assistant for a company that rents rooms to students. They have several apartments in the city, and each apartment has multiple single rooms. I’d like to create a bot that can answer tenants’ most basic questions (for example, what to do if the faucet is leaking) but most importantly, that can be consulted to check if a room is available in a given apartment.

I have a Google Sheet in Drive where column A contains the apartment addresses, column B has the room identification number (each apartment has multiple rooms), and columns G and H indicate the availability for the first and second semesters, respectively (if there’s a name in the cell, the room is occupied). Here’s the file, so you can understand: https://docs.google.com/spreadsheets/d/1kg051OsewlhUO_uYyA9Wd5HiXplPNff2vTCyo9-vujg/edit?usp=sharing

Do you think a bot like this is feasible? How can I set it up?

#2

No one? Any idea? I’m still in need of a solution :smiley: