Skip to main content

HYROS webhook to Google Sheet using Zapier


I’ve been trying to create Zap that can pull metrics like ROAS, AdSpend, Sales, Revenue, and etc. We want to automate that and generate report daily, dumping that to a sheet.

Need someone to correct me because I am not sure if I’m filling it out properly. I’m a beginner so I don’t really have in-depth understanding. Am I using the right trigger and action? TIA

 

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Badger
Forum|alt.badge.img+5
  • New
  • 134 replies
  • December 22, 2024

@LanceG. 

You are making a webhook POST request, this would send data not receive it. This hook would be better implemented inside HYROS but I have a feeling that there would not be a triggering event to fire it. Do see their documentation.  

Webhooks are typically used to send data to a specified URL, where it is caught and processed by the receiving system. In your case, you wish to make an API call, which involves sending a request to an endpoint and receiving data back as a response

Zapier does not appear to have an API request action set-up for HYROS. This may mean you will need to code one to ensure authorisation is correctly handled. AI should be able to help with this. I personally would use python as I find it easier to understand and ChatGPT is very helpful and with trial and error you can achieve significant results. 

Do read their API documentation here https://hyros.docs.apiary.io/# and webhook documentation https://docs.hyros.com/hyros-webhooks/


An example API CALL code block

import requests

# HYROS API configuration
API_KEY = 'your_api_key_here'  # Replace with your HYROS API key
ENDPOINT_URL = 'https://api.hyros.com/v1/attribution'  # Replace with the HYROS endpoint you need

# Define headers for the API request
headers = {
    'Authorization': f'Bearer {API_KEY}',
    'Content-Type': 'application/json',
}

# Define parameters for the API request (modify as needed)
params = {
    'start_date': '2023-01-01',  # Example parameter
    'end_date': '2023-12-31',    # Example parameter
}

try:
    # Make the GET request to the HYROS API
    response = requests.get(ENDPOINT_URL, headers=headers, params=params)

    # Check if the request was successful
    if response.status_code == 200:
        data = response.json()  # Parse JSON response
        # Use the data as needed
        return {'status': 'success', 'data': data}
    else:
        # Handle API errors
        return {
            'status': 'error',
            'code': response.status_code,
            'message': response.text
        }
except Exception as e:
    # Handle other errors (e.g., network issues)
    return {
        'status': 'error',
        'message': str(e)
    }


Hope this helps.
 


  • Author
  • Beginner
  • 2 replies
  • December 23, 2024

I appreciate this. It does makes sense now. I'll definitely try this and let you know how it goes. Thanks!


gatipe
  • Beginner
  • 9 replies
  • January 23, 2025
LanceG. wrote:

I’ve been trying to create Zap that can pull metrics like ROAS, AdSpend, Sales, Revenue, and etc. We want to automate that and generate report daily, dumping that to a sheet.

Need someone to correct me because I am not sure if I’m filling it out properly. I’m a beginner so I don’t really have in-depth understanding contact. Am I using the right trigger and action? TIA

 

It seems like you're on the right track, but make sure you're using the correct trigger for your data source (e.g., "New Report" or "New Metrics" from Facebook Ads or Google Ads) and the right action to "Create Spreadsheet Row" in Google Sheets. Double-check that you’re mapping the correct fields to the respective columns in your sheet (ROAS, AdSpend, Sales, etc.). If you’re unsure, reviewing the available triggers and actions in Zapier’s documentation will help clarify things. You can also try testing your Zap to ensure the data is flowing correctly into your sheet.


  • New
  • 1 reply
  • February 2, 2025
LanceG. wrote:

I appreciate this. It does makes sense now. I'll definitely try this and let you know how it goes. Thanks!

To connect HYROS webhook data to a Google Sheet using Zapier, you can create an automated workflow. First, set up a Zapier account and create a new Zap. For the trigger app, select "Webhooks by Zapier" and choose the "Catch Hook" trigger. This will generate a URL that you need to input into your HYROS account to send data from HYROS to Zapier via the webhook. Once Zapier receives the data, you can add an action step to send it to a Google Sheet.