Question about Google Sheets Integration

Questions
1

I have a sheet I manually update monthly with the number of appointments that I have had that month. What I would like to do is when an appointment is scheduled, the cell with the number of appointments is updated and the number is incremented by one.

I read through the docs but I’m still not sure of the answer. I’m assuming it’s possible but I’d like confirmation before I dive in.

Been really enjoying this app!

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hi @jbaggs, welcome to the community :tada:

I assume your problem is with writing the updated value, not so much the reading part, right?

This is a bit tricky as n8n’s Google Sheets node does not let you write into a specific cell. So you would have to make the required API request through the HTTP Request node. I’ve shared an example of how to so over here.

Hope this helps! Let me know if you have any further questions on this.

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.