What is your goal?
I want to read the latest data from a Google Sheet immediately after a new row is appended (using Google Sheets – Search Rows) with consistent performance (~1 second), in a LINE bot scenario.
What is the problem & what have you tried?
I have two LINE bot scenarios using the same Google Sheet.
Bot 1 appends a new row to the sheet.
Bot 2 uses Google Sheets – Search Rows to read the latest data based on user input.
This setup worked normally for over a month. Recently, immediately after a row is appended (manually or by Bot 1), the Search Rows module becomes extremely slow (from ~1 second to several minutes). After some time, it returns to normal speed. When another row is appended, the slowdown happens again.
This occurs even when:
The scenarios are not running concurrently
The Google Sheet is newly created and contains only ~20 rows
Only a single row is appended
What I have tried:
Creating a brand-new Google Sheet
Narrowing the column range (e.g., D–D instead of A–CZ)
Using only “Equal to” filters (no Contains)
Leaving Field Type empty
Adding delays after appending rows
The issue still happens and sometimes results in ESOCKETTIMEDOUT errors.
Is this expected behavior due to Google Sheets post-write latency, or is there a recommended pattern to reliably read data immediately after appending while still using the same sheet?
Error messages or input/output bundles
ESOCKETTIMEDOUT
Screenshots (scenario flow, module settings, errors)