Need help with database automation gmail to google sheets

Hello, I have been trying to automate a tedious job where transaction ID’s, price and date from a PayPal email should be identified and pasted in the next empty cell on a desired column on Google sheets. I have just strated with n8n and can’t wrap my head around this.
Date goes to column A in the next empty cell, transaction id into column B, description of the payment in column E and the price in column H
Could anybode give me some advice?

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:

We’ve created a new category for help with designing workflows, and I’ve moved your question there: Help me Build my Workflow. Find out how this category works by reading this topic.

HI @Emir_Mahmud

for what you want to achieve I would suggest using either the Information Extractor Node or even better connect a PayPal webhook straight to n8n to have a clean dataset transferred.

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