In this tutorial, you'll learn to import users from Adalo to Airtable. We'll find our Adalo API key and use the free Data Fetcher Airtable extension to connect to the Adalo API. This will let us import all of our users' data such as name, email and phone number through to Airtable. This tutorial is 100% no-code.
Adalo is an app-building software that lets you build websites and mobile applications without learning how to code. It's perfect for small businesses and startups looking to turn an app idea into reality real with a limited budget.
Every app in Adalo has a database with different collections. By default, every app starts with a 'User' collection, with properties such as 'name', 'email' and 'password'. You can then add other properties to the User collection. E.g., an app for sports fans might have a User property for their favourite team. You can learn more about Adalo databases here.
Add Data Fetcher to your base from the Airtable marketplace. This is a free extension that lets us import data from any other application, e.g. Adalo, Webflow etc., from within Airtable.
After you have added Data Fetcher to your base, you will need to create a free Data Fetcher account. Enter a password and click 'Sign up for free' or click 'Continue with Google'. Signing up for an account keeps your details secure. It is separate from your Airtable account.
Once you've signed up for a Data Fetcher account, you will land on the home screen. Click 'Create your first request' to go to the create request screen, where you will enter the details of our Adalo users collection.
On the create request screen in Data Fetcher, select 'Adalo' for the Application.
We now need to grab our API key from Adalo. Open Adalo and click on the settings icon in the left-hand menu. Then open the 'App Access' section. If you do not have an API key already, click 'Generate API Key' . Copy your Adalo API key.
Back in Data Fetcher, under Authorization, paste your Adalo API key.
Select 'Get all records in a database collection (e.g. Users)' for Endpoint.
Enter 'Import Adalo Users' for the request Name. Then click 'Save & Continue' in the bottom right corner.
In Adalo, open the 'Database' menu. Click on the '# Records' button next to the 'Users' collection. Copy the browser's URL.
Back in Data Fetcher, paste this URL into the Collection URL field.
Select the Output Table & View you want to import Adalo the users into.
Click 'Save & Run'.
Next, you need to configure how the available user collection fields should map to fields in the output table. The Response field mapping modal will have opened, where you can do this.
For each Adalo user field (e.g. 'Full name', 'email' & 'Phone number') you can either import or filter it. For an imported field, you can set whether to map them to an existing field or create a new field.
Make sure you import the 'Id' field, as we will use this to ensure the users we import into Airtable are kept in sync with any changes in Adalo. Import any other fields you want. Then click 'Save & Run'.
Data Fetcher will create the fields in the output table for any fields you mapped to 'New fields'. It will then run the request and import the users from Adalo to Airtable. Adalo has a limit of 100 users per run, so Data Fetcher may need to run on several pages in order to import all users.
Finally, we want to ensure Data Fetcher can match up users in Adalo with records in Airtable, even if we move those records around in Airtable. Click 'Advanced settings' to open the advanced output settings. Then for Update Based on Field, select 'Id'. Then click 'Save'.
Every time you click 'Run' on the create request screen, the Adalo users will be imported to Airtable. To avoid having to do this, you can use Data Fetcher's scheduled requests feature. This means the data will be automatically imported on the schedule that you select, e.g. once per hour.
This a paid feature, so first you need to upgrade. In Data Fetcher, scroll to Schedule and click 'Upgrade'.
A new tab will open where you can select a plan and enter your payment details to upgrade.
Return to the Data Fetcher extension and click 'I've done this'.
Under Schedule click '+ Authorize'.
Next, a window opens and you'll need to authorize the Airtable bases for Data Fetcher to have access to.
It's recommended that you choose 'All current and future bases in all current and future workspaces' to avoid any issues with unauthorized bases in the future.
Click 'Grant access'.
You'll now see Schedule this request has been switched on.
Select how often you want the request to run, e.g. 'Every 15 mins'. Click 'Save' The request will now run on the schedule and import the users from Adalo automatically.