Skip to content
Redesign your database schema so that it is normalized and contains the following data : VenturesContacts (A physical person)Ventures locationsDraw your database schema to document the new structure. You can use a dedicated software or hand-draw. Update your base in Airtable to fit this schema.
Design and visually represent a workflow to scrape the entirety of the finalists' pages at .Implement the scenarios you have designed in Make.
Create a form that can collect data about other impact projects. The minimum required fields are the project name, summary, source URL, and area of impact. Design, represent visually, and implement a scenario that adds and enriches data from your form to your Airtable base.
Add a location to each venture. The location should correspond to the main city in the area of impact, and include its latitude and longitude. This can be either part of the main scenario or a subscenario. Add a Sustainable Development Goal to each venture’s data. Each time a venture relates to SDG 14 (Life Below Water), its priority must be set to “High”.
Every time a venture is saved to the Airtable base and its priority is not “high”, a Slack notification is sent to a channel in your Slack workspace.Every time a venture’s priority is set to “high”, a Slack notification is sent to ANOTHER channel in your Slack workspace.
A link to your database and workflow schematics, or an image if you have hand-drawn them.A public link to your Airtable base.A screenshot of both Slack channels showing the different messages.
Linking records and tables in Airtable :
Scraping multiple pages with Make : How to find the sitemap.xml file of a website : Iterators in Make ( turn an array into individual elements to perform operations with them) : A guide to the map function in Make :
Project: Web scraping, Data Enrichment, and evaluation.
You operate as the partnerships and growth team of an impact-focused investment organization seeking to identify and engage high-potential climate ventures worldwide. Building on last week’s scraping workflows, you must design a multi-source intelligence system that consolidates publicly scraped data and privately submitted ventures into a unified database.
Using AI, you will extract data about, enrich, and evaluate each opportunity.
This is a project, not a practice exercise. This means that you must use creativity and common sense to deliver a solution that is functional and aligns with your company’s business goals.
Instructions
Database design
Scraping
Collecting
Enriching
Notifications
Delivery
Please submit :
Tutorials :
Database design
Multi-page Scraping
Notifications
Visualize geographical data on a map in
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.