Currently I need to read the excel data or append new data to that excel through using the Microsoft SharePoint node, How can I do that?
Because it look like can upload, update, get list, and something only. The function very limited
1 Like
Hi @Joe_B As i can see there is not as much as you can do on SharePoint using n8n’s native node, not saying it cannot do anything as it can do a lot operations in items and a lot of different operations but not in the ways you want to in your Excel file those are just listed here:
i highly recommend using google sheets which makes things lot easier to automate here, let me know if you need any help with that.
@Anshul_Namdev if like this situation, can we using the google sheets and done for all, then only upload to the SharePoint. The aim will be like store inside the SharePoint
@Joe_B Yes! We can do that i know it might increase a bit of a headache over including drive but it all would be nicely integrated and would be highly scalable, it would be something like this:
SharePoint (File → Download) → Google Drive (File → Upload) → Google Sheets (Sheet ops: Append/Update/Get rows) → Google Drive (File → Download, if needed for sharepoint) → SharePoint (File → Upload)
Like this approach is nice and would fill the requirement easily without any space for errors.
@Anshul_Namdev Thanks for giving the info, will try it later. If using the agent node, then the system message should be arrange well, otherwise the AI wouldn’t understand
1 Like
@Joe_B Yes! People actually underestimate system prompting and then when they test their workflow they wonder why the AI agent is not using tools, your system prompt will be the fine tuned musical instrument the better you made it the better AI will be able to create melodies, and when considering multiple operations like in your case we need to update/add/remove rows we need to provide multiple sheet tools so the AI agent really needs a strong strict set of rules in the system prompt and a direction so that it knows exactly what todo.
1 Like