Connecting shopify purchase email to a locked google sheet

hello, I am wondering if it is possible to have a shopify purchasers email automatically added to a locked google sheet?

once they buy, I am looking to have the customer email added to a locked google sheet where they then get access to this locked sheet - is this a possibility with n8n?

Thank you for your help & feedback!

Hey @kenekt, welcome to the community!

This might be doable but I can’t test this first hand as Shopify requires a paid account for most things.

If you create a Shopify trigger node and listen for relevant events (like Order Paid), would the data returned by the trigger node information include the email?

If so, you could afterwards use the Google Drive node to share the spreadsheet file with the user email address coming from your Shopify Trigger node.