Upload data from GoogleSheet

Hi guys,

I am stuck with a problem and need your suggestion.

What I am trying to do is this –

  1. There will be 2 types of users of my app – (general user) and (admin). Here admin means someone who will have rights to add / upload new data whereas others (general user) can only view data relevant to them.

  2. I have some screens for “admin users” who can upload data to the backend (Airtable via webapi). However, I want to give them an option of mass upload of data.

  3. I am trying to do this via Googlesheet and trying to parse the CSV received via webapi. I am able to get some data in this method but parsing a CSV seems to be too complex and messy. There must be an easier way to do this. Can you suggest please? Is there a way to parse this value into JSON?

Please note that my admin users are not very tech savvy and hence I am trying to use the GoogleSheet --> app method.

Waiting eagerly for some suggestion :worried:

thanks,
Somnath

1 Like