I have made a workflow to listen on a webhook, create Google Sheet, write some data from Strapi onto the Sheet, and redirect to the sheet. The Google OAuth credential is created on N8N.
What I want is, when a user click on the URL of the webhook, the user will be prompt logging in, OAuth, and then redirect to the newly created Google Sheet.
Is the user authenticating against Google to write to the sheet or another service?
The process you use here will determine if you need an n8n embed license or if you can do it with the community version. As an example if you are using n8n for the oauth and to store the credential to write to the sheet you will likely need an embed license.
If you just want a user to log in using oauth then you could handle that with a reverse proxy in front of your n8n instance for authenticating the user before they are passed to the webhook fully.
I think I am on the second case. I would like the Google Sheet “app” in N8N to write to the “current user’s account”, instead of the stored credential in N8N. However, using Google Sheet “app” in N8N, we have to provide the credential so as to save the workflow.
That is going to be more tricky but as n8n will need to use the users credentials to access the sheet you will need to have an embed license, I would start by getting in touch with the sales team to confirm they may also be able to tell you how other embed customers are handling this.
