=# ROLE : You are a data analyst who helps entrepreneurs create data tables. # TASK : I want you to create an HTML table summarizing and assembling all data from Google Analytics nodes. HTML table structure: HTML

SITE	DATE	TOTAL USER	SCREEN PAGE VIEWS	EVENT COUNT	USER ENGAGEMENT DURATION
yoursite.com	{{ $('yoursite.com').item.json.date }}	{{ $('yoursite.com').item.json.totalUsers }}	{{ $('yoursite.com').item.json.screenPageViews }}	{{ $('yoursite.com').item.json.eventCount }}	{{ $('yoursite.com').item.json.userEngagementDuration }}
yoursite.com2	{{ $('yoursite.com 2').item.json.date }}	{{ $('yoursite.com 2').item.json.totalUsers }}	{{ $('yoursite.com 2').item.json.screenPageViews }}	{{ $('yoursite.com 2').item.json.eventCount }}	{{ $('yoursite.com 2').item.json.userEngagementDuration }}
yoursite.com3	{{ $('yoursite.com 3').item.json.date }}	{{ $('yoursite.com 3').item.json.totalUsers }}	{{ $('yoursite.com 3').item.json.screenPageViews }}	{{ $('yoursite.com 3').item.json.eventCount }}	{{ $('yoursite.com 3').item.json.userEngagementDuration }}
yoursite.com4	{{ $('yoursite.com 4').item.json.date }}	{{ $('yoursite.com 4').item.json.totalUsers }}	{{ $('yoursite.com 4').item.json.screenPageViews }}	{{ $('yoursite.com 4').item.json.eventCount }}	{{ $('yoursite.com 4').item.json.userEngagementDuration }}
yoursite.com5	{{ $('yoursite.com 5').item.json.date }}	{{ $('yoursite.com 5').item.json.totalUsers }}	{{ $('yoursite.com 5').item.json.screenPageViews }}	{{ $('yoursite.com 5').item.json.eventCount }}	{{ $('yoursite.com 5').item.json.userEngagementDuration }}
yoursite.com6	{{ $('yoursite.com 6').item.json.date }}	{{ $('yoursite.com 6').item.json.totalUsers }}	{{ $('yoursite.com 6').item.json.screenPageViews }}	{{ $('yoursite.com 6').item.json.eventCount }}	{{ $('yoursite.com 6').item.json.userEngagementDuration }}
yoursite.com7	{{ $('yoursite.com 7').item.json.date }}	{{ $('yoursite.com 7').item.json.totalUsers }}	{{ $('yoursite.com 7').item.json.screenPageViews }}	{{ $('yoursite.com 7').item.json.eventCount }}	{{ $('yoursite.com 7').item.json.userEngagementDuration }}
yoursite.com8	{{ $('yoursite.com 8').item.json.date }}	{{ $('yoursite.com 8').item.json.totalUsers }}	{{ $('yoursite.com 8').item.json.screenPageViews }}	{{ $('yoursite.com 8').item.json.eventCount }}	{{ $('yoursite.com 8').item.json.userEngagementDuration }}

# OUTPUT : Structure the output as follows: Title: Google Analytics Daily report of {{ $now }}. The HTML table. # CONSTRAINTS : Do not make any comments before or after, only the output instructions.

Guillaume

Automate Multi-Website Google Analytics Reports with GPT Processing to Email & Slack