・
"I forgot to take the Google Ads report again..."
"Manually entering data into HubSpot takes a lot of time."
Are you struggling with data exchange in your daily tasks like this? Even if you understand the importance of measuring ad effectiveness and sharing with your team, manual repetition can lead to omissions and time loss. But what if you could automatically retrieve reports from Google Ads at a set time each week and reflect that content in a custom object in HubSpot? You can share accurate data with your team without worrying about errors.
In this article, we will introduce what you can do by integrating Google Ads and HubSpot, as well as detailed setup instructions. It's easy for anyone to integrate without code, so if you want to try automation, this is a must-read!
By using Yoom, you can easily integrate Google Ads and HubSpot without code. Yoom provides templates for integrating Google Ads and HubSpot, so you can achieve integration immediately just by registering, even without API knowledge.
By integrating the APIs of Google Ads and HubSpot, you can automatically link Google Ads data to HubSpot!
For example, you can automatically perform data integration like the following without human intervention.
By specifying the date and time, you can automatically reflect Google Ads information in HubSpot. This is expected to streamline campaign ad operations and enhance effectiveness. This flow is especially recommended for those who want to smoothly share Google Ads performance with their team!
By specifying the date and time, you can automate the entire process from obtaining the Google Ads report to adding a record in HubSpot. Automation can reduce routine tasks and alleviate the burden on the person in charge.
You can automatically share updates from Google Sheets, eliminating any time lag in information sharing.
This flow is recommended for those who manage tasks using shared Google Sheets and want to be notified of any updates.
Let's get started by creating a flow that integrates Google Ads and HubSpot!
We will use Yoom to proceed with the integration of Google Ads and HubSpot without any coding. If you do not have a Yoom account yet, please create one using the registration form here.
[What is Yoom]
In this session, we will create a flow that retrieves a Google Ads campaign report on a specified schedule and adds a record to a custom object in HubSpot!
The creation process is broadly divided into the following steps.
(1) After logging into Yoom, select "My Apps" from the left column and click "+ Add".
From the list of new connections in My Apps, click on Google Ads.
(2) From the Google login screen, click "Sign in with Google" and log in with your account.
(3) Select your account.
(4) Click "Next".
(5) Click "Continue".
(6) Next, connect HubSpot. Similarly, click HubSpot from the app list in Yoom.
If you have an account, click "Sign in to your HubSpot account".
(7) Enter your email address and click "Next".
(8) Enter your password on the next screen. Once entered, click "Log In".
Once the connection is complete, Google Ads and HubSpot will be registered in Yoom's My Apps.
This completes the My Apps registration.
Next, let's set up triggers using templates!
We will use the template introduced earlier.
Click "Try it" on the banner below to copy it.
Once copied, the template will be copied to your Yoom management screen as shown below, so press OK to proceed with the setup.
(1) Let's specify the date and time when the flow will be triggered using Yoom's schedule trigger!
Click on "When the specified schedule is reached" in the schedule trigger.
(2) From the "Specify Execution Time" screen of the schedule trigger, set the schedule.
This time, we checked the days of the week for notification and set the time to 9 AM.
In addition to specifying days of the week, you can also freely set dates or use Cron settings!
With Cron settings, you can finely adjust the execution frequency!
The image shows it set to execute at 5 PM.
For detailed instructions on Cron settings, please refer to the site below.
Once the schedule trigger settings are complete, click "Save" at the bottom.
(1) Next, connect with Google Ads to obtain campaign reports.
Click on "Obtain Campaign Reports."
(2) From the "Select Linked Account and Action" screen of Google Ads, check for any errors in the account information linked with Google Ads, keep the action as "Obtain Campaign Reports," and click "Next."
(3) From the "API Connection Settings" screen, check the red line, and enter the ad account ID and campaign name.
Scroll down and enter the "Start Date" and "End Date" using dates.
Once the input is complete, click "Test" at the bottom.
If the Google Ads information is reflected in the "Obtained Values," the test is successful.
If you're wondering "What are the obtained values?" please refer to the site below!
Click "Save" and proceed to the next step!
(1) Next, connect with HubSpot to create custom object records.
Click on "Create Custom Object Records."
(2) From the "Select Linked Account and Action" screen of HubSpot, check for any errors in the account information linked with HubSpot, keep the action as "Create Custom Object Records," and click "Next."
(3) From the "API Connection Settings" screen, select "Object Type" and "Internal Property Value" from the options.
Scroll down and enter the "Value" using the obtained values.
By using "Obtained Values," you can reference Google Ads information!
Well done! All settings are now complete.
Once the settings are complete, a menu like the one below will be displayed, so turn the trigger ON.
Try activating the flow bot and check if the Google Ads campaign report is obtained and a record is added to the custom object in HubSpot at the specified schedule!
Once posted in Microsoft Teams, it will automatically be reflected in Google Sheets, preventing manual transcription errors or omissions.
Leveraging the APIs of Google Ads and HubSpot enables the realization of various automations.
You can automatically retrieve the previous day's report from Google Ads every day and record it in Google Sheets or Microsoft Excel. Additionally, it is possible to automatically notify Slack or Microsoft Teams with the latest report obtained. Furthermore, integration can be achieved to retrieve Google Ads campaign reports when a video is uploaded to YouTube.
When there is a form submission or new contact registration in HubSpot, notifications can be sent to Google Chat and automated emails can be sent via Gmail. Additionally, when a contact is created, a Zoom meeting can be automatically scheduled, and its details can be sent via email.
How was it? By integrating Google Ads with HubSpot, you can expect to solve challenges such as "wanting to reduce the work of sharing ad reports," "wanting to deliver the latest data to the team in a timely manner," and "wanting to streamline daily routine tasks." By reducing manual work and automating data integration, more accurate and faster information sharing becomes possible.
By utilizing the no-code tool Yoom, you can easily integrate Google Ads and HubSpot without programming knowledge! If you're interested, create a free account first and check out the usability for yourself. Registration takes just 30 seconds. You can experience automatic integration immediately.
Why not significantly reduce the hassle of daily ad operations and data management and start smoother information sharing?
.avif)
.avif)
