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.
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.
…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.