Hi there,
I am using free service in n8n and I am looking for a support to provide information whether there is an option for pivot table or vlookup formula in the operation section for google sheet?
Is it something that only available for paid services? or there are alternative solution with any model to analyze and provide this solution?
Thank you
Hello @Filbert_Harvest
in n8n, you can create data that looks like a pivot table. Use the sum function to aggregate your data and move the data into a new sheet.
you can use the merge function in n8n to do lookups.
In addition to my post earlier, here’s a workflow that merges (vlookup) two sheets together. Then aggregates and outputs to another sheet.
n8n does not have a way to create a traditional pivot table in google sheets in any license models. We accomplish a pivot table like structure with an aggregate step.
If this response helped you, please click the heart to show that it is useful
If this response solved your issue, mark it as the solution to help the community
Did my answer solve your question?
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.