ACTION_ID: hubspot_lookup_object NAME: Hubspot: Lookup Record CATEGORY: sheets CREDITS: 0 Lookup record(s) in Hubspot, e.g. Contacts or Companies. ================================================================================ PREREQUISITE — USER ACTION REQUIRED ================================================================================ This action only works if the user has connected their HubSpot account in Floqer. The connection cannot be made via the API or by an AI agent. The user must do this themselves before this action will run: 1. Sign in to Floqer at https://app.floqer.com 2. Open the Connections page from the sidebar 3. Click HubSpot and complete the OAuth flow If the user has not connected HubSpot, this action will fail with a connection / authentication error. Before configuring or running this action, confirm with the user that the HubSpot connection exists. INDEX: 1. Inputs 2. Outputs 3. How to configure 4. Key notes 5. Where it fits in a workflow 6. When to use 7. When not to use ================================================================================ 1. INPUTS ================================================================================ hubspot_object (dropdown, required) Hubspot Object. Default: Contacts. Values: - { value: "contacts", label: "Contact" } (default) - { value: "companies", label: "Company" } operator (dropdown, optional) Operator. Default: OR. Values: - { value: "or", label: "OR" } (default) - { value: "and", label: "AND" } limit (number, optional) Limit. Default: 10. add_properties_and_their_values (dynamicJsonArray, optional) Add Properties and their Values. Select Properties from the object and add filter Values. Values from hubspot_properties. ================================================================================ 2. OUTPUTS ================================================================================ records (sectionList) — Records found in the lookup. Each record's columns depend on the selected object (contacts or companies). The full per-field set is listed below. Fields are tagged with the object they belong to via the "field" attribute on each entry. total_records (number) — Total Records. The total number of records found. --- Contacts fields (field: "contacts") ----------------------------- firstname (string) — Firstname lastname (string) — Lastname email (string) — Email work_email (string) — Work Email fax (string) — Fax zip (string) — Zip city (string) — City phone (string) — Phone photo (string) — Photo state (string) — State degree (string) — Degree gender (string) — Gender school (string) — School address (string) — Address company (string) — Company country (string) — Country hs_role (string) — Hs Role ip_city (string) — Ip City message (string) — Message website (string) — Website industry (string) — Industry ip_state (string) — Ip State jobtitle (string) — Jobtitle zain_new (string) — Zain New closedate (string) — Closedate ip_latlon (string) — Ip Latlon num_notes (string) — Num Notes ownername (string) — Ownername seniority (string) — Seniority createdate (string) — Createdate hs_persona (string) — Hs Persona ip_country (string) — Ip Country ip_zipcode (string) — Ip Zipcode owneremail (string) — Owneremail salutation (string) — Salutation start_date (string) — Start Date twitterbio (string) — Twitterbio hs_language (string) — Hs Language hs_latitude (string) — Hs Latitude hs_pipeline (string) — Hs Pipeline hs_sub_role (string) — Hs Sub Role hs_timezone (string) — Hs Timezone ip_holdings (string) — Ip Holdings linkedinbio (string) — Linkedinbio mobilephone (string) — Mobilephone company_size (string) — Company Size hs_gps_error (string) — Hs Gps Error hs_longitude (string) — Hs Longitude hs_object_id (string) — Hs Object Id hs_read_only (string) — Hs Read Only hs_seniority (string) — Hs Seniority hs_testpurge (string) — Hs Testpurge hs_twitterid (string) — Hs Twitterid hubspotscore (string) — Hubspotscore job_function (string) — Job Function numemployees (string) — Numemployees annualrevenue (string) — Annualrevenue date_of_birth (string) — Date Of Birth days_to_close (string) — Days To Close followercount (string) — Followercount hs_createdate (string) — Hs Createdate hs_email_open (string) — Hs Email Open hs_facebookid (string) — Hs Facebookid hs_is_contact (string) — Hs Is Contact hs_linkedinid (string) — Hs Linkedinid hs_state_code (string) — Hs State Code ip_state_code (string) — Ip State Code total_revenue (string) — Total Revenue twitterhandle (string) — Twitterhandle zain_how_you (string) — Zain How You field_of_study (string) — Field Of Study hs_buying_role (string) — Hs Buying Role hs_email_click (string) — Hs Email Click hs_ip_timezone (string) — Hs Ip Timezone hs_is_enriched (string) — Hs Is Enriched hs_is_unworked (string) — Hs Is Unworked hs_lead_status (string) — Hs Lead Status hs_legal_basis (string) — Hs Legal Basis lifecyclestage (string) — Lifecyclestage marital_status (string) — Marital Status graduation_date (string) — Graduation Date hs_all_team_ids (string) — Hs All Team Ids hs_email_bounce (string) — Hs Email Bounce hs_email_domain (string) — Hs Email Domain hs_email_optout (string) — Hs Email Optout hs_googleplusid (string) — Hs Googleplusid hs_gps_latitude (string) — Hs Gps Latitude hs_linkedin_url (string) — Hs Linkedin Url hs_owning_teams (string) — Hs Owning Teams hs_testrollback (string) — Hs Testrollback hs_was_imported (string) — Hs Was Imported hubspot_team_id (string) — Hubspot Team Id ip_country_code (string) — Ip Country Code military_status (string) — Military Status hs_all_owner_ids (string) — Hs All Owner Ids hs_email_replied (string) — Hs Email Replied hs_gps_longitude (string) — Hs Gps Longitude hs_journey_stage (string) — Hs Journey Stage hs_latest_source (string) — Hs Latest Source hs_object_source (string) — Hs Object Source hubspot_owner_id (string) — Hubspot Owner Id lastmodifieddate (string) — Lastmodifieddate kloutscoregeneral (string) — Kloutscoregeneral hs_count_is_worked (string) — Hs Count Is Worked hs_email_delivered (string) — Hs Email Delivered hs_google_click_id (string) — Hs Google Click Id hs_shared_team_ids (string) — Hs Shared Team Ids hs_shared_user_ids (string) — Hs Shared User Ids notes_last_updated (string) — Notes Last Updated recent_deal_amount (string) — Recent Deal Amount associatedcompanyid (string) — Associatedcompanyid currentlyinworkflow (string) — Currentlyinworkflow hs_all_contact_vids (string) — Hs All Contact Vids hs_analytics_source (string) — Hs Analytics Source hs_lastmodifieddate (string) — Hs Lastmodifieddate hs_object_source_id (string) — Hs Object Source Id hs_source_object_id (string) — Hs Source Object Id hs_source_portal_id (string) — Hs Source Portal Id linkedinconnections (string) — Linkedinconnections num_contacted_notes (string) — Num Contacted Notes relationship_status (string) — Relationship Status twitterprofilephoto (string) — Twitterprofilephoto hs_additional_emails (string) — Hs Additional Emails hs_analytics_revenue (string) — Hs Analytics Revenue hs_count_is_unworked (string) — Hs Count Is Unworked hs_email_bad_address (string) — Hs Email Bad Address hs_email_quarantined (string) — Hs Email Quarantined hs_facebook_click_id (string) — Hs Facebook Click Id hs_marketable_status (string) — Hs Marketable Status hs_merged_object_ids (string) — Hs Merged Object Ids hs_registered_member (string) — Hs Registered Member notes_last_contacted (string) — Notes Last Contacted num_associated_deals (string) — Num Associated Deals first_conversion_date (string) — First Conversion Date hs_analytics_last_url (string) — Hs Analytics Last Url hs_created_by_user_id (string) — Hs Created By User Id hs_full_name_or_email (string) — Hs Full Name Or Email hs_last_sms_send_date (string) — Hs Last Sms Send Date hs_last_sms_send_name (string) — Hs Last Sms Send Name hs_quarantined_emails (string) — Hs Quarantined Emails hs_updated_by_user_id (string) — Hs Updated By User Id num_conversion_events (string) — Num Conversion Events hs_analytics_first_url (string) — Hs Analytics First Url hs_clicked_linkedin_ad (string) — Hs Clicked Linkedin Ad hs_country_region_code (string) — Hs Country Region Code hs_email_is_ineligible (string) — Hs Email Is Ineligible hs_facebook_ad_clicked (string) — Hs Facebook Ad Clicked hs_first_outreach_date (string) — Hs First Outreach Date hs_linkedin_ad_clicked (string) — Hs Linkedin Ad Clicked hs_notes_last_activity (string) — Hs Notes Last Activity hs_notes_next_activity (string) — Hs Notes Next Activity hs_object_source_label (string) — Hs Object Source Label hs_registration_method (string) — Hs Registration Method hs_unique_creation_key (string) — Hs Unique Creation Key hs_v2_date_exited_lead (string) — Hs V2 Date Exited Lead recent_conversion_date (string) — Recent Conversion Date recent_deal_close_date (string) — Recent Deal Close Date first_deal_created_date (string) — First Deal Created Date hs_email_last_open_date (string) — Hs Email Last Open Date hs_email_last_send_date (string) — Hs Email Last Send Date hs_pinned_engagement_id (string) — Hs Pinned Engagement Id hs_v2_date_exited_other (string) — Hs V2 Date Exited Other webinareventlastupdated (string) — Webinareventlastupdated hs_email_first_open_date (string) — Hs Email First Open Date hs_email_first_send_date (string) — Hs Email First Send Date hs_email_last_click_date (string) — Hs Email Last Click Date hs_email_last_email_name (string) — Hs Email Last Email Name hs_email_last_reply_date (string) — Hs Email Last Reply Date hs_first_closed_order_id (string) — Hs First Closed Order Id hs_latest_open_lead_date (string) — Hs Latest Open Lead Date hs_object_source_user_id (string) — Hs Object Source User Id hs_predictivescoringtier (string) — Hs Predictivescoringtier hs_sequences_is_enrolled (string) — Hs Sequences Is Enrolled hs_social_twitter_clicks (string) — Hs Social Twitter Clicks hs_v2_date_entered_other (string) — Hs V2 Date Entered Other hs_whatsapp_phone_number (string) — Hs Whatsapp Phone Number notes_next_activity_date (string) — Notes Next Activity Date hs_avatar_filemanager_key (string) — Hs Avatar Filemanager Key hs_calculated_merged_vids (string) — Hs Calculated Merged Vids hs_cross_sell_opportunity (string) — Hs Cross Sell Opportunity hs_email_first_click_date (string) — Hs Email First Click Date hs_email_first_reply_date (string) — Hs Email First Reply Date hs_email_optout_397525458 (string) — Hs Email Optout 397525458 hs_email_optout_397525459 (string) — Hs Email Optout 397525459 hs_email_optout_397525460 (string) — Hs Email Optout 397525460 hs_marketable_reason_type (string) — Hs Marketable Reason Type hs_mobile_sdk_push_tokens (string) — Hs Mobile Sdk Push Tokens hs_object_source_detail_1 (string) — Hs Object Source Detail 1 hs_object_source_detail_2 (string) — Hs Object Source Detail 2 hs_object_source_detail_3 (string) — Hs Object Source Detail 3 hs_predictivecontactscore (string) — Hs Predictivecontactscore hs_social_facebook_clicks (string) — Hs Social Facebook Clicks hs_social_last_engagement (string) — Hs Social Last Engagement hs_social_linkedin_clicks (string) — Hs Social Linkedin Clicks hs_user_ids_of_all_owners (string) — Hs User Ids Of All Owners hs_v2_latest_time_in_lead (string) — Hs V2 Latest Time In Lead hs_all_accessible_team_ids (string) — Hs All Accessible Team Ids hs_analytics_last_referrer (string) — Hs Analytics Last Referrer hs_analytics_source_data_1 (string) — Hs Analytics Source Data 1 hs_analytics_source_data_2 (string) — Hs Analytics Source Data 2 hs_calculated_phone_number (string) — Hs Calculated Phone Number hs_document_last_revisited (string) — Hs Document Last Revisited hs_emailconfirmationstatus (string) — Hs Emailconfirmationstatus hs_first_order_closed_date (string) — Hs First Order Closed Date hs_has_active_subscription (string) — Hs Has Active Subscription hs_inferred_language_codes (string) — Hs Inferred Language Codes hs_latest_meeting_activity (string) — Hs Latest Meeting Activity hs_latest_source_timestamp (string) — Hs Latest Source Timestamp hs_sales_email_last_opened (string) — Hs Sales Email Last Opened hs_v2_date_exited_customer (string) — Hs V2 Date Exited Customer hs_v2_latest_time_in_other (string) — Hs V2 Latest Time In Other hubspot_owner_assigneddate (string) — Hubspot Owner Assigneddate first_conversion_event_name (string) — First Conversion Event Name hs_analytics_first_referrer (string) — Hs Analytics First Referrer hs_analytics_last_timestamp (string) — Hs Analytics Last Timestamp hs_analytics_num_page_views (string) — Hs Analytics Num Page Views hs_calculated_mobile_number (string) — Hs Calculated Mobile Number hs_content_membership_email (string) — Hs Content Membership Email hs_content_membership_notes (string) — Hs Content Membership Notes hs_created_by_conversations (string) — Hs Created By Conversations hs_data_privacy_ads_consent (string) — Hs Data Privacy Ads Consent hs_email_hard_bounce_reason (string) — Hs Email Hard Bounce Reason hs_email_quarantined_reason (string) — Hs Email Quarantined Reason hs_feedback_last_nps_rating (string) — Hs Feedback Last Nps Rating hs_job_change_detected_date (string) — Hs Job Change Detected Date hs_last_sales_activity_date (string) — Hs Last Sales Activity Date hs_last_sales_activity_type (string) — Hs Last Sales Activity Type hs_latest_sequence_enrolled (string) — Hs Latest Sequence Enrolled hs_live_enrichment_deadline (string) — Hs Live Enrichment Deadline hs_marketable_until_renewal (string) — Hs Marketable Until Renewal hs_notes_next_activity_type (string) — Hs Notes Next Activity Type hs_recent_closed_order_date (string) — Hs Recent Closed Order Date hs_sa_first_engagement_date (string) — Hs Sa First Engagement Date hs_sales_email_last_clicked (string) — Hs Sales Email Last Clicked hs_sales_email_last_replied (string) — Hs Sales Email Last Replied hs_sequences_enrolled_count (string) — Hs Sequences Enrolled Count hs_time_to_first_engagement (string) — Hs Time To First Engagement hs_v2_date_entered_customer (string) — Hs V2 Date Entered Customer associatedcompanylastupdated (string) — Associatedcompanylastupdated hs_analytics_first_timestamp (string) — Hs Analytics First Timestamp hs_content_membership_status (string) — Hs Content Membership Status hs_feedback_last_survey_date (string) — Hs Feedback Last Survey Date hs_predictivecontactscore_v2 (string) — Hs Predictivecontactscore V2 hs_sa_first_engagement_descr (string) — Hs Sa First Engagement Descr hs_social_google_plus_clicks (string) — Hs Social Google Plus Clicks hs_v2_date_exited_evangelist (string) — Hs V2 Date Exited Evangelist hs_v2_date_exited_subscriber (string) — Hs V2 Date Exited Subscriber num_unique_conversion_events (string) — Num Unique Conversion Events recent_conversion_event_name (string) — Recent Conversion Event Name surveymonkeyeventlastupdated (string) — Surveymonkeyeventlastupdated hs_associated_target_accounts (string) — Hs Associated Target Accounts hs_contact_enrichment_opt_out (string) — Hs Contact Enrichment Opt Out hs_customer_agent_lead_status (string) — Hs Customer Agent Lead Status hs_email_optout_survey_reason (string) — Hs Email Optout Survey Reason hs_first_engagement_object_id (string) — Hs First Engagement Object Id hs_latest_qualified_lead_date (string) — Hs Latest Qualified Lead Date hs_latest_sequence_ended_date (string) — Hs Latest Sequence Ended Date hs_messaging_engagement_score (string) — Hs Messaging Engagement Score hs_v2_cumulative_time_in_lead (string) — Hs V2 Cumulative Time In Lead hs_v2_date_entered_evangelist (string) — Hs V2 Date Entered Evangelist hs_v2_date_entered_subscriber (string) — Hs V2 Date Entered Subscriber hs_v2_date_exited_opportunity (string) — Hs V2 Date Exited Opportunity hs_v2_latest_time_in_customer (string) — Hs V2 Latest Time In Customer hs_calculated_form_submissions (string) — Hs Calculated Form Submissions hs_conversations_visitor_email (string) — Hs Conversations Visitor Email hs_feedback_last_nps_follow_up (string) — Hs Feedback Last Nps Follow Up hs_social_num_broadcast_clicks (string) — Hs Social Num Broadcast Clicks hs_v2_cumulative_time_in_other (string) — Hs V2 Cumulative Time In Other hs_v2_date_entered_opportunity (string) — Hs V2 Date Entered Opportunity engagements_last_meeting_booked (string) — Engagements Last Meeting Booked hs_analytics_average_page_views (string) — Hs Analytics Average Page Views hs_feedback_show_nps_web_survey (string) — Hs Feedback Show Nps Web Survey hs_predictivecontactscorebucket (string) — Hs Predictivecontactscorebucket hs_v2_latest_time_in_evangelist (string) — Hs V2 Latest Time In Evangelist hs_v2_latest_time_in_subscriber (string) — Hs V2 Latest Time In Subscriber hs_email_hard_bounce_reason_enum (string) — Hs Email Hard Bounce Reason Enum hs_feedback_last_ces_survey_date (string) — Hs Feedback Last Ces Survey Date hs_last_sales_activity_timestamp (string) — Hs Last Sales Activity Timestamp hs_latest_disqualified_lead_date (string) — Hs Latest Disqualified Lead Date hs_latest_sequence_enrolled_date (string) — Hs Latest Sequence Enrolled Date hs_latest_sequence_finished_date (string) — Hs Latest Sequence Finished Date hs_v2_latest_time_in_opportunity (string) — Hs V2 Latest Time In Opportunity hs_all_assigned_business_unit_ids (string) — Hs All Assigned Business Unit Ids hs_analytics_last_visit_timestamp (string) — Hs Analytics Last Visit Timestamp hs_email_optimal_send_day_of_week (string) — Hs Email Optimal Send Day Of Week hs_email_optimal_send_time_of_day (string) — Hs Email Optimal Send Time Of Day hs_enriched_email_bounce_detected (string) — Hs Enriched Email Bounce Detected hs_feedback_last_csat_survey_date (string) — Hs Feedback Last Csat Survey Date hs_first_subscription_create_date (string) — Hs First Subscription Create Date hs_v2_cumulative_time_in_customer (string) — Hs V2 Cumulative Time In Customer hs_analytics_first_visit_timestamp (string) — Hs Analytics First Visit Timestamp hs_analytics_num_event_completions (string) — Hs Analytics Num Event Completions hs_employment_change_detected_date (string) — Hs Employment Change Detected Date hs_feedback_last_ces_survey_rating (string) — Hs Feedback Last Ces Survey Rating hs_latest_sequence_unenrolled_date (string) — Hs Latest Sequence Unenrolled Date hs_latest_subscription_create_date (string) — Hs Latest Subscription Create Date hs_prospecting_agent_last_enrolled (string) — Hs Prospecting Agent Last Enrolled hs_sa_first_engagement_object_type (string) — Hs Sa First Engagement Object Type hs_content_membership_registered_at (string) — Hs Content Membership Registered At hs_feedback_last_csat_survey_rating (string) — Hs Feedback Last Csat Survey Rating hs_v2_cumulative_time_in_evangelist (string) — Hs V2 Cumulative Time In Evangelist hs_v2_cumulative_time_in_subscriber (string) — Hs V2 Cumulative Time In Subscriber hs_calculated_phone_number_area_code (string) — Hs Calculated Phone Number Area Code hs_email_customer_quarantined_reason (string) — Hs Email Customer Quarantined Reason hs_email_sends_since_last_engagement (string) — Hs Email Sends Since Last Engagement hs_last_metered_enrichment_timestamp (string) — Hs Last Metered Enrichment Timestamp hs_returning_to_office_detected_date (string) — Hs Returning To Office Detected Date hs_sequences_actively_enrolled_count (string) — Hs Sequences Actively Enrolled Count hs_v2_cumulative_time_in_opportunity (string) — Hs V2 Cumulative Time In Opportunity hs_v2_date_exited_salesqualifiedlead (string) — Hs V2 Date Exited Salesqualifiedlead hs_content_membership_email_confirmed (string) — Hs Content Membership Email Confirmed hs_feedback_last_ces_survey_follow_up (string) — Hs Feedback Last Ces Survey Follow Up hs_searchable_calculated_phone_number (string) — Hs Searchable Calculated Phone Number hs_time_to_move_from_lead_to_customer (string) — Hs Time To Move From Lead To Customer hs_v2_date_entered_salesqualifiedlead (string) — Hs V2 Date Entered Salesqualifiedlead engagements_last_meeting_booked_medium (string) — Engagements Last Meeting Booked Medium engagements_last_meeting_booked_source (string) — Engagements Last Meeting Booked Source hs_calculated_phone_number_region_code (string) — Hs Calculated Phone Number Region Code hs_feedback_last_csat_survey_follow_up (string) — Hs Feedback Last Csat Survey Follow Up hs_searchable_calculated_mobile_number (string) — Hs Searchable Calculated Mobile Number hs_calculated_phone_number_country_code (string) — Hs Calculated Phone Number Country Code hs_contact_enrichment_opt_out_timestamp (string) — Hs Contact Enrichment Opt Out Timestamp hs_v2_latest_time_in_salesqualifiedlead (string) — Hs V2 Latest Time In Salesqualifiedlead engagements_last_meeting_booked_campaign (string) — Engagements Last Meeting Booked Campaign hs_email_recipient_fatigue_recovery_time (string) — Hs Email Recipient Fatigue Recovery Time hs_v2_date_exited_marketingqualifiedlead (string) — Hs V2 Date Exited Marketingqualifiedlead hs_prospecting_agent_total_enrolled_count (string) — Hs Prospecting Agent Total Enrolled Count hs_user_ids_of_all_notification_followers (string) — Hs User Ids Of All Notification Followers hs_v2_date_entered_marketingqualifiedlead (string) — Hs V2 Date Entered Marketingqualifiedlead hs_currently_enrolled_in_prospecting_agent (string) — Hs Currently Enrolled In Prospecting Agent hs_membership_has_accessed_private_content (string) — Hs Membership Has Accessed Private Content hs_analytics_last_touch_converting_campaign (string) — Hs Analytics Last Touch Converting Campaign hs_content_membership_follow_up_enqueued_at (string) — Hs Content Membership Follow Up Enqueued At hs_time_to_move_from_subscriber_to_customer (string) — Hs Time To Move From Subscriber To Customer hs_user_ids_of_all_notification_unfollowers (string) — Hs User Ids Of All Notification Unfollowers hs_v2_cumulative_time_in_salesqualifiedlead (string) — Hs V2 Cumulative Time In Salesqualifiedlead hs_v2_latest_time_in_marketingqualifiedlead (string) — Hs V2 Latest Time In Marketingqualifiedlead hs_analytics_first_touch_converting_campaign (string) — Hs Analytics First Touch Converting Campaign hs_prospecting_agent_actively_enrolled_count (string) — Hs Prospecting Agent Actively Enrolled Count hs_time_to_move_from_opportunity_to_customer (string) — Hs Time To Move From Opportunity To Customer hs_membership_last_private_content_access_date (string) — Hs Membership Last Private Content Access Date hs_time_between_contact_creation_and_deal_close (string) — Hs Time Between Contact Creation And Deal Close hs_v2_cumulative_time_in_marketingqualifiedlead (string) — Hs V2 Cumulative Time In Marketingqualifiedlead hs_content_membership_registration_email_sent_at (string) — Hs Content Membership Registration Email Sent At hs_content_membership_registration_domain_sent_to (string) — Hs Content Membership Registration Domain Sent To hs_time_between_contact_creation_and_deal_creation (string) — Hs Time Between Contact Creation And Deal Creation hs_searchable_calculated_international_phone_number (string) — Hs Searchable Calculated International Phone Number hs_time_to_move_from_salesqualifiedlead_to_customer (string) — Hs Time To Move From Salesqualifiedlead To Customer hs_searchable_calculated_international_mobile_number (string) — Hs Searchable Calculated International Mobile Number hs_time_to_move_from_marketingqualifiedlead_to_customer (string) — Hs Time To Move From Marketingqualifiedlead To Customer custom_fields (json) — Custom Fields --- Companies fields (field: "companies") --------------------------- zip (string) — Zip city (string) — City name (string) — Name type (string) — Type phone (string) — Phone state (string) — State domain (string) — Domain address (string) — Address country (string) — Country website (string) — Website about_us (string) — About Us address2 (string) — Address2 industry (string) — Industry timezone (string) — Timezone closedate (string) — Closedate is_public (string) — Is Public num_notes (string) — Num Notes ownername (string) — Ownername createdate (string) — Createdate owneremail (string) — Owneremail twitterbio (string) — Twitterbio description (string) — Description hs_keywords (string) — Hs Keywords hs_latitude (string) — Hs Latitude hs_logo_url (string) — Hs Logo Url hs_pipeline (string) — Hs Pipeline linkedinbio (string) — Linkedinbio facebookfans (string) — Facebookfans founded_year (string) — Founded Year hs_gps_error (string) — Hs Gps Error hs_longitude (string) — Hs Longitude hs_object_id (string) — Hs Object Id hs_read_only (string) — Hs Read Only hubspotscore (string) — Hubspotscore annualrevenue (string) — Annualrevenue days_to_close (string) — Days To Close hs_createdate (string) — Hs Createdate hs_state_code (string) — Hs State Code hs_task_label (string) — Hs Task Label total_revenue (string) — Total Revenue twitterhandle (string) — Twitterhandle hs_is_enriched (string) — Hs Is Enriched hs_lead_status (string) — Hs Lead Status lifecyclestage (string) — Lifecyclestage googleplus_page (string) — Googleplus Page hs_all_team_ids (string) — Hs All Team Ids hs_country_code (string) — Hs Country Code hs_gps_latitude (string) — Hs Gps Latitude hs_num_blockers (string) — Hs Num Blockers hs_owning_teams (string) — Hs Owning Teams hs_time_in_lead (string) — Hs Time In Lead hs_was_imported (string) — Hs Was Imported hubspot_team_id (string) — Hubspot Team Id hs_all_owner_ids (string) — Hs All Owner Ids hs_csm_sentiment (string) — Hs Csm Sentiment hs_gps_longitude (string) — Hs Gps Longitude hs_object_source (string) — Hs Object Source hs_quick_context (string) — Hs Quick Context hs_revenue_range (string) — Hs Revenue Range hs_time_in_other (string) — Hs Time In Other hubspot_owner_id (string) — Hubspot Owner Id twitterfollowers (string) — Twitterfollowers web_technologies (string) — Web Technologies hs_employee_range (string) — Hs Employee Range hs_industry_group (string) — Hs Industry Group hs_num_open_deals (string) — Hs Num Open Deals hs_target_account (string) — Hs Target Account numberofemployees (string) — Numberofemployees hs_linkedin_handle (string) — Hs Linkedin Handle hs_shared_team_ids (string) — Hs Shared Team Ids hs_shared_user_ids (string) — Hs Shared User Ids notes_last_updated (string) — Notes Last Updated recent_deal_amount (string) — Recent Deal Amount total_money_raised (string) — Total Money Raised hs_analytics_source (string) — Hs Analytics Source hs_date_exited_lead (string) — Hs Date Exited Lead hs_lastmodifieddate (string) — Hs Lastmodifieddate hs_object_source_id (string) — Hs Object Source Id hs_source_object_id (string) — Hs Source Object Id hs_time_in_customer (string) — Hs Time In Customer hs_total_deal_value (string) — Hs Total Deal Value num_contacted_notes (string) — Num Contacted Notes hs_date_entered_lead (string) — Hs Date Entered Lead hs_date_exited_other (string) — Hs Date Exited Other hs_is_target_account (string) — Hs Is Target Account hs_merged_object_ids (string) — Hs Merged Object Ids hs_parent_company_id (string) — Hs Parent Company Id hs_research_agent_id (string) — Hs Research Agent Id notes_last_contacted (string) — Notes Last Contacted num_associated_deals (string) — Num Associated Deals facebook_company_page (string) — Facebook Company Page first_conversion_date (string) — First Conversion Date hs_additional_domains (string) — Hs Additional Domains hs_created_by_user_id (string) — Hs Created By User Id hs_date_entered_other (string) — Hs Date Entered Other hs_time_in_evangelist (string) — Hs Time In Evangelist hs_time_in_subscriber (string) — Hs Time In Subscriber hs_updated_by_user_id (string) — Hs Updated By User Id linkedin_company_page (string) — Linkedin Company Page num_conversion_events (string) — Num Conversion Events hs_is_intent_monitored (string) — Hs Is Intent Monitored hs_last_open_task_date (string) — Hs Last Open Task Date hs_notes_last_activity (string) — Hs Notes Last Activity hs_notes_next_activity (string) — Hs Notes Next Activity hs_num_child_companies (string) — Hs Num Child Companies hs_num_decision_makers (string) — Hs Num Decision Makers hs_object_source_label (string) — Hs Object Source Label hs_time_in_opportunity (string) — Hs Time In Opportunity hs_unique_creation_key (string) — Hs Unique Creation Key recent_conversion_date (string) — Recent Conversion Date recent_deal_close_date (string) — Recent Deal Close Date first_deal_created_date (string) — First Deal Created Date hs_analytics_num_visits (string) — Hs Analytics Num Visits hs_date_exited_customer (string) — Hs Date Exited Customer hs_pinned_engagement_id (string) — Hs Pinned Engagement Id num_associated_contacts (string) — Num Associated Contacts first_contact_createdate (string) — First Contact Createdate hs_date_entered_customer (string) — Hs Date Entered Customer hs_last_logged_call_date (string) — Hs Last Logged Call Date hs_object_source_user_id (string) — Hs Object Source User Id notes_next_activity_date (string) — Notes Next Activity Date hs_avatar_filemanager_key (string) — Hs Avatar Filemanager Key hs_date_exited_evangelist (string) — Hs Date Exited Evangelist hs_date_exited_subscriber (string) — Hs Date Exited Subscriber hs_ideal_customer_profile (string) — Hs Ideal Customer Profile hs_intent_signals_enabled (string) — Hs Intent Signals Enabled hs_object_source_detail_1 (string) — Hs Object Source Detail 1 hs_object_source_detail_2 (string) — Hs Object Source Detail 2 hs_object_source_detail_3 (string) — Hs Object Source Detail 3 hs_user_ids_of_all_owners (string) — Hs User Ids Of All Owners hs_all_accessible_team_ids (string) — Hs All Accessible Team Ids hs_analytics_latest_source (string) — Hs Analytics Latest Source hs_analytics_source_data_1 (string) — Hs Analytics Source Data 1 hs_analytics_source_data_2 (string) — Hs Analytics Source Data 2 hs_date_entered_evangelist (string) — Hs Date Entered Evangelist hs_date_entered_subscriber (string) — Hs Date Entered Subscriber hs_date_exited_opportunity (string) — Hs Date Exited Opportunity hs_latest_meeting_activity (string) — Hs Latest Meeting Activity hubspot_owner_assigneddate (string) — Hubspot Owner Assigneddate first_conversion_event_name (string) — First Conversion Event Name hs_analytics_last_timestamp (string) — Hs Analytics Last Timestamp hs_analytics_num_page_views (string) — Hs Analytics Num Page Views hs_date_entered_opportunity (string) — Hs Date Entered Opportunity hs_last_booked_meeting_date (string) — Hs Last Booked Meeting Date hs_last_sales_activity_date (string) — Hs Last Sales Activity Date hs_last_sales_activity_type (string) — Hs Last Sales Activity Type hs_live_enrichment_deadline (string) — Hs Live Enrichment Deadline hs_notes_next_activity_type (string) — Hs Notes Next Activity Type hs_sales_email_last_replied (string) — Hs Sales Email Last Replied hs_analytics_first_timestamp (string) — Hs Analytics First Timestamp hs_predictivecontactscore_v2 (string) — Hs Predictivecontactscore V2 recent_conversion_event_name (string) — Recent Conversion Event Name hs_target_account_probability (string) — Hs Target Account Probability hs_time_in_salesqualifiedlead (string) — Hs Time In Salesqualifiedlead hs_research_agent_execution_id (string) — Hs Research Agent Execution Id engagements_last_meeting_booked (string) — Engagements Last Meeting Booked hs_annual_revenue_currency_code (string) — Hs Annual Revenue Currency Code hs_intent_visitors_last_30_days (string) — Hs Intent Visitors Last 30 Days hs_last_sales_activity_timestamp (string) — Hs Last Sales Activity Timestamp hs_all_assigned_business_unit_ids (string) — Hs All Assigned Business Unit Ids hs_analytics_last_visit_timestamp (string) — Hs Analytics Last Visit Timestamp hs_analytics_latest_source_data_1 (string) — Hs Analytics Latest Source Data 1 hs_analytics_latest_source_data_2 (string) — Hs Analytics Latest Source Data 2 hs_date_exited_salesqualifiedlead (string) — Hs Date Exited Salesqualifiedlead hs_intent_page_views_last_30_days (string) — Hs Intent Page Views Last 30 Days hs_num_contacts_with_buying_roles (string) — Hs Num Contacts With Buying Roles hs_time_in_marketingqualifiedlead (string) — Hs Time In Marketingqualifiedlead hs_analytics_first_visit_timestamp (string) — Hs Analytics First Visit Timestamp hs_date_entered_salesqualifiedlead (string) — Hs Date Entered Salesqualifiedlead hs_last_logged_outgoing_email_date (string) — Hs Last Logged Outgoing Email Date hs_most_recent_de_anonymized_visit (string) — Hs Most Recent De Anonymized Visit hs_analytics_latest_source_timestamp (string) — Hs Analytics Latest Source Timestamp hs_customer_success_ticket_sentiment (string) — Hs Customer Success Ticket Sentiment hs_last_metered_enrichment_timestamp (string) — Hs Last Metered Enrichment Timestamp hs_date_exited_marketingqualifiedlead (string) — Hs Date Exited Marketingqualifiedlead engagements_last_meeting_booked_medium (string) — Engagements Last Meeting Booked Medium engagements_last_meeting_booked_source (string) — Engagements Last Meeting Booked Source hs_date_entered_marketingqualifiedlead (string) — Hs Date Entered Marketingqualifiedlead hs_target_account_recommendation_state (string) — Hs Target Account Recommendation State engagements_last_meeting_booked_campaign (string) — Engagements Last Meeting Booked Campaign hs_user_ids_of_all_notification_followers (string) — Hs User Ids Of All Notification Followers hs_analytics_last_touch_converting_campaign (string) — Hs Analytics Last Touch Converting Campaign hs_user_ids_of_all_notification_unfollowers (string) — Hs User Ids Of All Notification Unfollowers hs_analytics_first_touch_converting_campaign (string) — Hs Analytics First Touch Converting Campaign hs_latest_createdate_of_active_subscriptions (string) — Hs Latest Createdate Of Active Subscriptions hs_target_account_recommendation_snooze_time (string) — Hs Target Account Recommendation Snooze Time num_conversion_events_cardinality_sum_d095f14b (string) — Num Conversion Events Cardinality Sum D095f14b hs_analytics_num_visits_cardinality_sum_53d952a6 (string) — Hs Analytics Num Visits Cardinality Sum 53d952a6 hs_predictivecontactscore_v2_next_max_max_d4e58c1e (string) — Hs Predictivecontactscore V2 Next Max Max D4e58c1e hs_analytics_num_page_views_cardinality_sum_e46e85b0 (string) — Hs Analytics Num Page Views Cardinality Sum E46e85b0 recent_conversion_date_timestamp_latest_value_72856da1 (string) — Recent Conversion Date Timestamp Latest Value 72856da1 first_contact_createdate_timestamp_earliest_value_78b50eea (string) — First Contact Createdate Timestamp Earliest Value 78b50eea hs_analytics_last_timestamp_timestamp_latest_value_4e16365a (string) — Hs Analytics Last Timestamp Timestamp Latest Value 4e16365a recent_conversion_event_name_timestamp_latest_value_66c820bf (string) — Recent Conversion Event Name Timestamp Latest Value 66c820bf hs_analytics_last_visit_timestamp_timestamp_latest_value_999a0fce (string) — Hs Analytics Last Visit Timestamp Timestamp Latest Value 999a0fce hs_analytics_last_touch_converting_campaign_timestamp_latest_value_81a64e30 (string) — Hs Analytics Last Touch Converting Campaign Timestamp Latest Value 81a64e30 custom_fields (json) — Custom fields ================================================================================ 3. HOW TO CONFIGURE ================================================================================ Resolve the property list for the chosen object via Get Action Field Options: POST /api/v1/workflows/{workflow_id}/sheets/{sheet_id}/actions/{action_instance_id}/options/add_properties_and_their_values (body: { "context": { "hubspot_object": "contacts" } }) Configure Action body: { "inputs": { "hubspot_object": "contacts", "operator": "or", "limit": 10, "add_properties_and_their_values": [ { "name": "email", "value": "{{input.email}}" }, { "name": "domain", "value": "{{input.domain}}" } ] } } Field-by-field: - hubspot_object Object type — `contacts` or `companies` only (Lookup is limited to those two; for Deals / Leads, use Update / Upsert by ID). - operator `or` (any criterion matches; default) or `and` (all criteria match). - limit Max records returned. Default 10. - add_properties_and_their_values `[{name, value}]` filter criteria. Property names are HubSpot internal names — fetch via Get Action Field Options. ================================================================================ 4. KEY NOTES ================================================================================ - Lookup is limited to `contacts` and `companies`. To find Deals or Leads by external value, use `http_api_call` to call HubSpot's Search API directly. - The `records` output is a `structured_array` — reference individual columns via the 3-segment shape `{{.records.}}`. - Every contact / company property your HubSpot org has defined is surfaced as a column on the `records` output (the long list below). Use Get Action Field Options on `add_properties_and_their_values` to enumerate them per object. - The HubSpot connection must live on the API key's user account. ================================================================================ 5. WHERE IT FITS IN A WORKFLOW ================================================================================ Pattern: hubspot_lookup_object -> workflow_if_else (records found) -> hubspot_update_object or downstream branching. ================================================================================ 6. WHEN TO USE ================================================================================ Use hubspot_lookup_object to read existing HubSpot Contacts or Companies by filter properties. ================================================================================ 7. WHEN NOT TO USE ================================================================================ Need create-or-update by unique property -> hubspot_upsert_object (https://floqer.com/docs/action-detail/hubspot_upsert_object.txt) Need to always create -> hubspot_create_object (https://floqer.com/docs/action-detail/hubspot_create_object.txt) Need to update by HubSpot ID -> hubspot_update_object (https://floqer.com/docs/action-detail/hubspot_update_object.txt) ================================================================================ This file is maintained manually. Last updated: 2026-04-28. Full interactive reference: https://floqer.com/docs/reference Action catalog: https://floqer.com/docs/action-catalog.txt