What this workflow does
This workflow manages rental data in Google Sheets automatically. It adds new rental listings, finds listings by city, changes rent amounts, and reads the data back. The goal is to save time and stop mistakes from manual work.
The workflow uses unique IDs to keep data correct. It runs steps to append new data, search existing rows, update rent values, and then get the latest data from the sheet.
Who should use this workflow
This workflow is for anyone who manages rental properties and keeps records in Google Sheets. It helps people who update many listings across different places and want to avoid errors.
No deep technical skills are needed, but some familiarity with n8n and Google Sheets helps. It also fits users wanting to automate manual spreadsheet tasks to gain more time and improve data trust.
Tools and Services Used
- Google Sheets: Stores and manages rental data.
- n8n Platform: Runs the automation workflow connecting Google Sheets operations.
- Google OAuth 2.0 Credentials: Secure access to Google Sheets via API.
Beginner step-by-step: How to build this in n8n
Importing and Setup
- Download the workflow file using the Download button on this page.
- Open the n8n editor and choose Import from File to upload the workflow.
- After import, connect Google Sheets OAuth 2.0 credentials in all Google Sheets nodes.
- Update the Sheet ID value to your own Google Sheet’s ID if different.
- Verify any static inputs, like city names or rent values in the Set nodes, match your needs.
- Test run the workflow once by triggering the Manual Trigger node.
- Check if the new row is added and rent values update correctly in Google Sheets.
- When satisfied, activate the workflow by switching the active toggle ON to run automatically.
Want to run scheduled updates? Replace the Manual Trigger with a schedule node for daily or weekly runs.
If hosting on your own server, find support for self-host n8n.
Workflow Inputs, Processing, and Outputs
Inputs
- New rental data with fields like ID, Name, Rent, and City.
- Lookup city name string to search existing listings.
Processing Steps
- Append: Add new rental entry to Google Sheets with a random unique ID.
- Lookup: Find all existing rows matching the city name.
- Set: Increase rent values on matched rows by a fixed amount (e.g., 100).
- Update: Write new rent values back to exact rows using ID as key.
- Read: Read entire sheet data to confirm all data is current and formatted.
Outputs
- New row added with unique ID.
- List of rows from the chosen city with updated rent.
- Complete table data showing all rental listings after changes.
Common Mistakes and How to Avoid Them
- An error in inserting Google Sheets credentials can block access.
- Wrong Sheet ID or range stops adding or updating data correctly.
- Incorrect lookup column name (e.g., typo in city column) returns no results.
- Failure to use a unique key like “ID” in update node risks wrong rows changing.
Customization Ideas
- Change the city filter in the lookup node to find rentals in other cities like “Paris” or “New York”.
- Adjust the rent increase amount in the Set node to fit real rent changes.
- Add more columns like “Bedrooms” or “Availability” by extending the range and updating the Set nodes accordingly.
- Use a scheduled trigger instead of manual trigger for automatic regular updates.
- Feed dynamic rental data through a form or webhook instead of static data for new entries.
Summary of Benefits and Outcomes
✓ Adds rental entries automatically with unique IDs.
✓ Finds and filters rental listings by city easily.
✓ Updates rent values safely using unique identifiers.
✓ Reads back updated data for confirmation.
✓ Saves time by replacing repetitive manual tasks.
✓ Improves data accuracy and consistency in Google Sheets.