Download documents from Google Drive and attach them to a Gmail

Questions
1

I’m trying to get a file downloaded from google drive and attached to a gmail email to send it to a recipient. If in the send email I put the email address directly, then send the email with the attachment without giving me any kind of problem. My problem is when I want the email address I extracted from google sheets to be detected.

Can you tell me some method to achieve something like the example I propose below: I want to put in a telegram chat that an email be sent to Mr. Johnson with document X attached. Therefore, 1. using an AI agent I want it to extract the contact and address from a Google Sheets datasheet. 2 Find the document I ask you to send to Mr. Johnson from my google drive and attach it to the gmail email so that I can send it to Mr. Johnson.
I have a client who is asking me for this and I can’t get it, I’ve been trying for 4 days.

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

Hi @Hermanos_Ficticios welcome to the community.

I suggest doing the n8n quick start and courses. This seems like a pretty simple use case that should be clear once finished with the courses.

It’s hard for the community to help if you don’t share what you have.

It sounds like part of the issue might be trying to have the AI do too much, try to have the spreadsheets and drive functions be completely detached from the AI, maybe only having the AI select the IDs or Names