CSV uploads in your app

You may have come across the need to allow CSV uploading to add data to your app but there is no Glide version of a feature like this. There are a number of ways to do this and I’m just adding my method here. This can be done without using a third-party tool like Make or Zapier, and no need to use Call API; it uses Glide’s workflows.

Rather than type out the whole process, here’s a video on how to do this (updated link):
https://www.tella.tv/video/cmafm6m77000x0bl48cd6hl6a/view

Let me know any questions and certainly, and suggestions on how to make this better. :slight_smile:

8 Likes

To get rid of that “copy of mutations” column, you just need a Query JSON node as the first step in your workflow, and then pass the generated JSON. Also, you shouldn’t need all those lookup columns, as you should be able to target the values directly within the workflow loop.

4 Likes

When I try doing a Query JSON in the Workflow I get the error;

Any idea why? This is why I was copying the mutations.

If I point the Query JSON at the copy it works but then the Query JSON of the First Name;

…shows the whole row of that JSON;
{
“email”: “amelia.e@example.com”,
“phone”: “555-123-4567”,
“Last Name”: “Earhart”,
“First Name”: “Amelia”,
“School Name”: “Oshawa High School”
}

This would seem to indicate that the text version of the JSON is not properly formatted. The result is that it didn’t work in the Workflow and I had to resort to the example I show in the video.

I feel like the problem is in the CSV to JSON column but I don’t know that for sure.

1 Like

As per discussion on our call just now :wink:

I eagerly await the updated video :joy:

1 Like

Huge thanks to @Darren_Murphy for helping me streamline this! It works much better and is a simpler setup.

Link to the video

1 Like