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
Page 1 / 1
@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.
# 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.
I appreciate this. It does makes sense now. I'll definitely try this and let you know how it goes. Thanks!
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.
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.