https://discord.gg/botpress logo
Google Sheets Integration
# 🤝help
a
Hi, I am trying to use the Google Sheets Integration to automatically sync a spreadsheet to my knowledgebase as I update the spreadsheet in Google Sheets. I have successfully connected Google Sheets to botpress using the spreadsheet id, service account private key, and service account email. (no errors) I assumed this would automatically import the spreadsheet into a new table (as indicated by your help bot) which could then be used by a new knowledge base, but that did not happen. Is there a way to sync the spreadsheet automatically to a new table using the Google Sheets Integration. Am I missing a step?
l
You need a method to sync data - just connecting Google Sheets with Botpress wont sync data I suggest to - Create a Botpress workflow - Add a Google Sheets → Read Range card - Loop through rows and Insert Row into a Botpress Table - Connect your Knowledge Base to that Table you can automate this using a Cron trigger (every X minutes/hours)
4 Views