Convert Google Sheet data to Local data so i can use it latter in a loop?

Hello,
I try to create an flow where i have a loop which checks in a google spreadsheet all the rows that have name: beer, and extracts the ids of all beers.

The problem is that there are lots of loops to be done (236) and google sheet seems to be very slow and not the best idea for this type of data, so i thought if is not possible maybe somehow to save the google locally and latter iterate the local file ?

But so far i did not find a way that would be working , can you recoomend me what would you do in this case?

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:

@Victor_Sava Why not cgheck all the rows using one API call. Dont use the loops

2 Likes

Hey @Victor_Sava,

You could also try using the Google Drive node to download the file as a CSV which would then let you read it with the spreadsheet node and do what you need to.

Thank you , this is what i did, converted to a local file and yes ,this is what i look for

1 Like