Integrate Your AppSheet with n8n using custom community node

[Rifad]

Hello AppSheet Community,

I’ve built an AppSheet API node for n8n that eliminates the need for hardcoding API calls when working with AppSheet. This node lets you easily add, read, update, and delete records in your AppSheet tables directly from n8n workflows.

What Problem Does It Solve?
Instead of writing custom code or hardcoding API integrations, this node encapsulates all the required API calls. It provides configurable parameters (like Locale, Location, and Timezone) and allows you to supply your record data as JSON, simplifying your workflow automation.

How to Install on n8n Cloud:

1. Log in to Your n8n.io Account:
   Open your browser and log in at n8n.io.

2. Navigate to Settings:
   In the n8n editor, click the Settings icon (top-right).

3. Go to Community Nodes:
   Select Community Nodes from the Settings menu. You’ll be able to search for custom nodes here.

4. Search for "n8n-nodes-rifad-appsheet":
   Type the package name in the search bar, and when it appears, click Install.

5. Add the AppSheet Node to Your Workflow:
   Once installed, add the AppSheet node to your workflow, configure it with your AppSheet API credentials, and start automating without any hardcoding.

Give it a try and let us know your feedback.

Happy Automating!

[iPlomberie]

I'm new to n8n but quite ok with Apssheet. Does your node access data only it is in a appsheet database or it can access the datasource (eg : google sheet)

[Rifad]

Yes, it can access any AppSheet table with any datasource. I translated the entire AppSheet API into an n8n node.

Refer this on how appsheet api works: https://support.google.com/appsheet/answer/10105768?hl=en&sjid=2256301022331897878-NC

[GNF]

@Rifad , can you help me how to connect n8n and appsheet?