I am brand new to n8n. I am setting it up because the company i work for needs to streamline a lot of our processes. For instance the problem im trying to solve now is i want to send an email to certain emails every time a row is added to a google sheet. This will function as our order form and lets the warehouse know they need to send out a specific item. Is there somewhere i could use to get a better understanding of how to work with this amazing program?
PS: I read through all of the documentation concerning the google api.
Ok, there is a workaround using a free plugin for google sheets called trigger and send. This plugin will send an HTTP Request to an endpoint every time a form (associated with a spreadsheet) is submitted. You can catch that HTTP Request using the webhook node and then send the email using one of the nodes to do so.
So is it possible to use this same idea to say create a user in google workspace based on the information from the webhook then add that user to a group? Im a complete newb when it comes to this program and am honestly struggling to wrap my head around it.
Yes, this is completely posible. You just have to connect the Webhook to the G Admin node. I guessing you need to use the data from the webhook node in the G Admin node and this can be done expressions.
More info about expressions can be found here.
Im sorry to keep being a bother. SO i’ve got it successfully creating the user. But now i need it to actually add that user to a group based on what department is listed.
The idea is this. I fill out a google form with the techs information, it creates a user adds that user to the company group, and then whatever other group they are selected for. It then sends that user an email with their log in information. It would also send an email to our billing manager and HR department saying hey we’ve hired this person at this much from this state. Here is their contact information.
I have not got it to successfully add the created user to the group. That doesn’t actually seem to be possible with n8n… Am i just going overboard here?
You are not bothering me at all. This is one of the main purposes of the community.
ah, that is a good use case. Yeah, that should be possible using the group:create on the G Suite Node. Can you please share the workflow with me so that I can have a proper look? Also If you can tell me how the data the Webhook node is receiving looks like.
To share the workflow just select all nodes, copy them, and then paste them here. Do not worry about credentials as they are not copied.