Inconsistent Data: GA4 to Google Sheets Workflow (Yesterday’s Data Discrepancy)

Questions
1

Hi everyone,

I’ve set up a workflow in n8n to fetch data from GA4 (Google Analytics 4) and transfer it to a Google Sheet, pulling data for the previous day. The workflow has been running smoothly, and the data for past dates is correct.

However, I noticed that the data transferred for yesterday is lower than what is shown in GA4 for the same date. I checked the data for other dates in the past, and it matches perfectly—only yesterday’s data seems to have this discrepancy.

Has anyone encountered this issue or know what could be causing the mismatch just for yesterday’s data?

Summary of my workflow:

  1. Fetch yesterday’s data from GA4.
  2. Transfer the data to Google Sheets.

Any insights or suggestions would be greatly appreciated!

Thanks in advance for your help!

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

Hi @Shahla_Aminaei ,

Welcome to the community! :dizzy:

Do you see any discrepancy in the logs from yesterday compmared to the previous runs?
Would you be able to do a manual execution to pull yesterday’s data and see if the outcome changes?

Also, what version on n8n are you on and where are you running it?

5

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