grist-core icon indicating copy to clipboard operation
grist-core copied to clipboard

Better integrations

Open paulfitz opened this issue 4 years ago • 22 comments

Every app needs to integrate with every other app these days. Grist supports Zapier, has an API, and uses an open data format (Sqlite), but could do more to support the universe of possible integrations.

paulfitz avatar Jul 19 '21 18:07 paulfitz

Note to include Google Drive syncing in the universe of better integrations.

anaisconce avatar Aug 07 '21 13:08 anaisconce

Pabbly please!

csdoes avatar Aug 08 '21 18:08 csdoes

We started a poll at the community forum at https://community.getgrist.com/t/what-data-view-and-3-rd-party-integrator-would-you-like-to-see-next/37 (where Pabbly is currently winning).

dsagal avatar Aug 08 '21 18:08 dsagal

I've split Pabbly support out into https://github.com/gristlabs/grist-core/issues/74 - we're working on it @csdoes

paulfitz avatar Aug 17 '21 14:08 paulfitz

Other issues relevant to better integrations are #76 (webhooks) and #75 (record-based API).

paulfitz avatar Aug 17 '21 15:08 paulfitz

Update: Pabbly now supports Grist actions: https://www.pabbly.com/connect/integrations/grist/

paulfitz avatar Aug 25 '21 12:08 paulfitz

Note to add support for importing sqlite files

anaisconce avatar Aug 30 '21 20:08 anaisconce

Update: Integrately now supports Grist integrations!

anaisconce avatar Sep 02 '21 19:09 anaisconce

Request to add IFTTT https://ifttt.com/ 💪

anaisconce avatar Sep 15 '21 13:09 anaisconce

Update. Here are the links to integrators who support Grist, as of September 30, 2021:

  • Zapier: https://zapier.com/apps/grist/integrations
  • Integrately: https://integrately.com/integrations/grist
  • Pabbly: https://www.pabbly.com/connect/integrations/grist/
  • KonnectzIT: https://plan.konnectzit.com/feedback/grist-integration
  • n8n: https://n8n.io/integrations/n8n-nodes-base.grist

dsagal avatar Sep 19 '21 00:09 dsagal

n8n is the only open source self hosted tool in your list -- amazing piece of software. Unfortunately it only works with the website Grist, not the self hosted one.

asitemade4u avatar Dec 01 '21 00:12 asitemade4u

Good point @asitemade4u - we'll look at tweaking the n8n integration. In the meantime, looking at the code at https://github.com/n8n-io/n8n/commit/4bce33a5306585d0b767b0db8dbf0ae0ac0f8836, getgrist.com is just mentioned in two non-comments, so if you were up for it it might be an easy change to make yourself.

paulfitz avatar Dec 01 '21 15:12 paulfitz

@asitemade4u @paulfitz done ;) https://github.com/n8n-io/n8n/pull/2788

tennox avatar Feb 09 '22 10:02 tennox

Meanwhile https://github.com/n8n-io/n8n/pull/2847 got merged. Are there already sketches about how a Grist Trigger for n8n could look like?

almereyda avatar Aug 12 '22 22:08 almereyda

@almereyda the code from the Zapier integration might be a helpful reference:

  • https://github.com/gristlabs/grist-zapier
  • an example instant trigger - https://github.com/gristlabs/grist-zapier/blob/main/triggers/updated_record_instant.js
  • this relies on our as yet unofficial api for webhooks - https://github.com/gristlabs/grist-core/issues/76#issuecomment-1025802544

paulfitz avatar Aug 13 '22 18:08 paulfitz

😍 Webhooks ... maybe some time in autumn I could try to adapt the Zapier example, if noone else steps up earlier.

almereyda avatar Aug 15 '22 17:08 almereyda

Requesting integration with make.com Thanks!

brandonkal avatar Sep 04 '22 04:09 brandonkal

Adding Grist to NextCloud would be great. Currently NextCloud seems focused on Collabora/LibreOffice, but innovative solutions like Grist would be a better way forward for NextCloud. For Grist it would mean access to all the European users looking for GDPR-friendly Office 365 replacements.

I guess the way to do this would be to add Grist as an "app" in NextCloud.

audunmb avatar Oct 21 '22 13:10 audunmb

Hm, the user who created the Grist template for Unraid is also a NextCloud user. Let me ping him and see if he might have insights about how to do this, @audunmb

@brandonkal I see Grist on make.com https://www.make.com/en/integrations/grist (formerly Integromat!)

anaisconce avatar Oct 25 '22 17:10 anaisconce