Activepieces Tables ✨

Hi there!

We are back again with another new feature to help your automation journey be much more enjoyable :grin:

Background

Many of your automations revolve around data, we know this because Google Sheets is the TOP used piece (you can sort pieces by popularity here).

This is our thought process:

  • Many sheets are created ONLY to support your automations.
  • Automation data is scattered between 3rd parties and Activepieces.
  • Google Sheets doesn’t perfectly integrate with Activepieces (slow webhooks, connectivity issues and more)
  • We have a Storage piece that serves other purposes and is not as powerful as sheets

What’s new?

We decided to own the full automation experience and offer Tables as part of your favorite automation software, Activepieces – all in ONE place :exploding_head:

Now on, you’ll notice Tables in your sidebar!

After you create the table, give it a name and create the fields you want they can be (Text, Number or Date), you can go to your flow and start automating using by using the Tables piece.

Let us know what you think down below about this feature :point_down:

6 Likes

Hey there @Abdul!

It’s fantastic to see yet another feature aimed at making automation more seamless. The introduction of Tables feels like a fantastic upgrade, particularly for those who need a simpler way to organise and access their data. It’s clear that, as always, you’ve taken user feedback on board, putting in the effort to refine the “Storage” piece and making it far more user-friendly. This update truly seems like a clever way to streamline processes.

I’m genuinely excited to see how this feature will shape the overall experience. A big thank you for your ongoing commitment to refining ActivePieces – it certainly doesn’t go unnoticed!

Keep up the fantastic work! :partying_face:

EDIT:

One thing that immediately jumps out is that it would be nice (which I guess you probably have planned in the works anyway), if we could simply populate the table data by pasting from Google/Excel Sheets (or other table like software).

Currently, I can see it being a bit cumbersome having to add every entry 1 by 1 manually, especially if we have 100s/1000s of records to input.

(Note that I don’t, but I figured why not use and extreme case for example purposes)

I get we can probably set up a flow to retrieve this data from a Sheet/table to populate the tables inside of ActivePieces, but it would be nice to have an option for offline documents too. (e.g. - excel)

I mean if we are just adding data to it from a flow, then it shouldn’t matter so much, but if we wanted to read that data, it might make more sense. I gather this would replace the need for things like Google Sheets, and Excel as well as storage pieces? Or is the idea here to make these limited and still only store data to then port across to another table like software?

1 Like

Great new feature team! I believe this is a great improvement for those not familiar with the storage piece and how to use it.

1 Like

Awesome new feature! Already love these tables, bye bye Google sheets!

1 Like

Hello @Abdul,
Awesome New Feature !

I was trying it but seems Tables are not triggered for new records when I use it as beginning task.

1 Like

The team is looking into it, sorry!

Please check again now, it has been fixed.

Hello @Abdul

Still having the same issue.
I have two processes.

  • One contains an http webhook that retrieve data and store it in a table (which is working fine)
  • the other one is triggered when a new record is added into the table (which is not working)

This is AMAZING!!! Thank you very much! :pray:

2 Likes

Can you please republish your flow and make sure your piece version for tables is 0.0.3 ?
image

Fantastic addition!

lets-get-this-party-started-yeah

1 Like

Is it possible through a flow to import a table from a google sheet?

You can enter a space in the Google Sheet Find Rows node for What to Search, and set rows to return to something like 10,000 (or however many you know you want to collect) and then pass over to AP’s Tables node.

But that doesn’t import the structure right? I was wondering if its possible to bring in a table with row 1 as the column names.

Ah, yeah that doesn’t currently look possible but I may be wrong.

1 Like

Hi @Christian_DeRamos

I think this request is related → https://feedback.activepieces.com/p/csv-import-for-tables

We will prioritize the import soon :smiley: the more feedback the faster it goes out of beta!