Overview
Product Hunt is a popular online platform that enables its users to share and discover new products. With this spreadsheet integration for Google Sheets and Microsoft Excel, you can lookup and import current posts and new product information from Product Hunt without leaving your spreadsheet.
What you can do
With this integration, you can:
- Lookup and import current Product Hunt posts and product information
- Lookup and import current Product Hunt comments matching a search term
- Search past posts on Product Hunt based on a date
- Search and filter New Jobs posts
- Search and filter Maker Activity posts
What you need
You need to have a Product Hunt account to use this integration. Also, if you haven't already installed the Flex.io add-on for Excel or Google Sheets, you need to set this up as well.
Functions and Syntax
This integration for Microsoft Excel or Google Sheets includes the following functions:
Product Hunt Posts
Returns a list of producthunt posts for today
Syntax
=FLEX("YOUR_TEAM_NAME/producthunt-posts", [properties])
Sample Usage
=FLEX("YOUR_TEAM_NAME/producthunt-posts", "*") =FLEX("YOUR_TEAM_NAME/producthunt-posts", "id, name, url, tagline")
Parameters
| Property | Type | Description | Required |
|---|---|---|---|
properties |
array | The properties to return (defaults to all properties). See "Returns" for a listing of the available properties. | false |
Returns
| Property | Type | Description |
|---|---|---|
id |
string | The id for the product post |
name |
string | The name of the product being featured |
url |
string | The url of the product being featured |
tagline |
string | The tagline of the product being featured |
description |
string | A description of the product being featured |
createdAt |
string | The date the product post was created |
featuredAt |
string | The date the product was featured |
Need help?
Have questions? Need help getting started? Need other Product Hunt templates or functions for Microsoft Excel or Google Sheets? Chat with us; we're happy to help!