I have 25+ storage crates with random things, and would like to make a list of the contents in Google Sheets, and have a Google Home skill where I can ask it either of these two for example:
A. SEARCH FOR ITEM:
"What crate is(are) HDMI Cables in?" where it responds with "Crate 12" (or "Crates 7 & 12" if in multiple crates)
B. LIST CRATE CONTENTS:
"What is in Crate 7?" where it responds with "Crate 7 contains..." and lists the contents from that Google Sheet column.
All data will be typed in manually, I just need it to search from the list and respond.
5 freelancere byder i gennemsnit $410 på dette job
Hello? [login to view URL] This is what i have done in google script with api Google Voice Search from Google Sheets. [login to view URL] Thanks. Best regards.