Import Data

Ask the community
,
1

Hello everyone,
I can now import and export data by pasting JSON data into the text box as illustrated by the WIX article. However I need to provide an easy way for the user to update the data by themselves. Is it possible to -

  1. connect the data collection to a Google Sheet so that the user can edit the data in google sheet, click a button in a WIX page and WIX will fetch the data from Google Sheet?
    Or
  2. user selects a JSON file in a WIX page, click a button and the JSON data is imported? This is similar to pasting the data but I dont want to have the user paste the data. Opening a file is easier to understand.
    Thanks for your help!
    Ken
2

Yes, you can connect Airtable for an example which is very powerful for this kind of work. You can connect Google Sheet as well. Or you could build an easy data managing page in Wix Code.

Coding without limits!

3

Thanks Andreas,
Can you provide brief instructions on how I can get Airtable working with WIX? Thanks.
Ken