wordpress to google sheet - google analytics to google sheet

[serwar24554]

i am currently saving all my newly published posts on google sheet. i want to add the google analytics sessions traffic data for each post in its row( 30 days since it published). how can i create this workflow.

 

[ArshilAhmad]

Hi @serwar24554,

Please check out the video shared below:

 

[serwar24554]

there does not seem to be api dimensions for post title . how can i achieve it?

 

[ArshilAhmad]

Could you please elaborate a bit more on what you mean?

 

[serwar24554]

here is what i want. any post that is added in google sheet. now this post has post title, link, description, image in google sheet. i want to update the row with the views this post got from google analytics. or in simple words the traffic it received lets say in form of sessions. i want to update the row with the traffic it achieved in last 48 hours. how can i do this.

 

[Soumya Tripathi]

Hello @serwar24554
You can achieve this using Pabbly Connect with the following steps:

Workflow Steps:​

1. Trigger Application:
   Schedule (Pabbly) – Schedule Workflow
   
   • Set this to run once per day (or as per your requirement) to automate the process daily.
2. DateTime Formatter (Pabbly): Current Date
   
   • This will fetch the current date in UTC.
   • If you want it in your local time zone, use the "Format Date with Time Zone" action event.
3. Google Sheets: Lookup Spreadsheet Rows V2
   
   • In your Google Sheet, add a separate column to log the current date against each new post.
   • This will help Pabbly filter and fetch only the latest posts added within the last 24 hours.
   • Match the date format with the output from the DateTime Formatter step.
   • Capture the response with Simple Response turned off.
4. Iterator (Pabbly): Process Arrays
   
   • This helps to loop through each post (row) retrieved from the Google Sheet.
5. Google Analytics 4: Run Report
   
   • Here Property ID, Metric Name and Filter by Metric are required fields.
6. Google Sheets: Update Row
   
   • Update the same row in your Google Sheet with the traffic data (e.g., sessions) you received from GA4.

You can try the above setup to achieve your use case.