Fill records with information found on a website
Budget: €8 – €30 EUR
I need help to fill around 300 lines of data which includes for each line, Person information to fill, and Product information to fill. Those data will be filled directly online in an Airtable database.
Starting from line 280 of the Podcast episode tab, you will need to:
- Fill "Website Link" column if not already done (the corresponding link to the podcast episode, I'll give you the main website when the project start)
- Add the "Showcased products" if not done. (the product name is often mentioned in the title or you can find it in "The Show Note" on the Website. You must type the product name to see if it already exists in the database. If it already exists select it from the list. If not, you can create a new one. If it already exists there are chances information is already filled as well.
- Click on the added "Showcased products" and fill those information:
- Founder name: Select the founder name from the list (it’s the name of the interviewee). Type its first letters to filter out the names. Don’t copy past names this could create duplicates.
- URL: the Product Website URL. You can find it in the "Show note" on the website or on google.
- Pricing: Most of those products will have a Pricing page (subscription page) URL. Sometimes everything is on one page, if it's the case don't fill.
- Short description: This will be the first big title you see on a page (H1)
- Long description: Usually a more detailed paragraph or sentence below the Short Description.
- Year of creation if you can find it
- Product hunt page: Find if this product has a page on producthunt : https://www.producthunt.com/
Be careful some products have similar names. If you find the product add its page link.
- Click on the "Interviewee" name and fill those information :
- Product: Select the previously added product from the list
- Personal website: If mentioned on the website
- Twitter Name: only add the username from the twitter link. For example https://twitter.com/brennandunn will be : brennandunn
- Linkedin name: Only add the linkedin name from linkedin link. For example https://www.linkedin.com/in/brennandunn will be brennandunn
Twitter and Linkedin links are often mentioned on the website. If not please make a quick search on google to see if you can find the person.
Books mentioned: On each episode on the website, there is 1 or multi-book mentioned in Book Recommendation. Click on Add records and search if the book already exists in the database. If yes select it. If not, you need to add a new record and add the Author of the book as well.
Please be clean, you can easily make a mess or add double information.
Starting from line 280 of the Podcast episode tab, you will need to:
- Fill "Website Link" column if not already done (the corresponding link to the podcast episode, I'll give you the main website when the project start)
- Add the "Showcased products" if not done. (the product name is often mentioned in the title or you can find it in "The Show Note" on the Website. You must type the product name to see if it already exists in the database. If it already exists select it from the list. If not, you can create a new one. If it already exists there are chances information is already filled as well.
- Click on the added "Showcased products" and fill those information:
- Founder name: Select the founder name from the list (it’s the name of the interviewee). Type its first letters to filter out the names. Don’t copy past names this could create duplicates.
- URL: the Product Website URL. You can find it in the "Show note" on the website or on google.
- Pricing: Most of those products will have a Pricing page (subscription page) URL. Sometimes everything is on one page, if it's the case don't fill.
- Short description: This will be the first big title you see on a page (H1)
- Long description: Usually a more detailed paragraph or sentence below the Short Description.
- Year of creation if you can find it
- Product hunt page: Find if this product has a page on producthunt : https://www.producthunt.com/
Be careful some products have similar names. If you find the product add its page link.
- Click on the "Interviewee" name and fill those information :
- Product: Select the previously added product from the list
- Personal website: If mentioned on the website
- Twitter Name: only add the username from the twitter link. For example https://twitter.com/brennandunn will be : brennandunn
- Linkedin name: Only add the linkedin name from linkedin link. For example https://www.linkedin.com/in/brennandunn will be brennandunn
Twitter and Linkedin links are often mentioned on the website. If not please make a quick search on google to see if you can find the person.
Books mentioned: On each episode on the website, there is 1 or multi-book mentioned in Book Recommendation. Click on Add records and search if the book already exists in the database. If yes select it. If not, you need to add a new record and add the Author of the book as well.
Please be clean, you can easily make a mess or add double information.