To get started with Weld, please visit our extension store page. Then, click "Install". After you accept the permissions that pop up, you can add the extension from any Google Sheet! Just open a new or existing Google Sheet (make sure you're using the same Google account that you installed the extension with), then click addons and select "Weld" from the dropdown. That's it!
Click Addons from the Google Sheet menu, then click "Weld". From there, a new tab will open for where you will need to authenticate your Google account and you should be logged in!
To add Weld to any Google Sheet, just click "Addons" from the toolbar at the top, followed by "Get add-ons". After selecting "Get add-ons", search for "Weld AI" in the window that appears, then click "Install".After accepting the permissions, you should be good to go to start using Weld!
While we don't support Microsoft Excel yet, it is still easy to export to the Microsoft supported format, .xlsx by clicking File, followed by Download, then Microsoft Excel (.xlsx).
It's simple to create a report of your ad data in Google Sheets using Weld. First, activate the extension by clicking Add-ons in the Google Sheet's toolbar, followed by Weld, then Start.
When you run Weld the first time, we'll ask you to select a data source to import your information.
Select one of the Data providers to get started. You will have to authenticate the first time you activate a data provider in a tab. After you have completed your authentication, close the tab and return to your Google Sheet to start creating your report.
First, we'll select a "View" for the data. This option allows you to choose from an existing View you have setup within Google Analytics.After choosing a View, I'll select a date range, in this case, the last 30 days.
In this example, we'll create a report showing visitors to our website over the last 30 days using Google Analytics.
Then, I'll move to the "Metrics" field and type "users" in order to pull in the user (visitor) counts from the last 30 days.
Then I'll move to "Dimensions" and type "date" to bring in the date user's visited our site.
Finally, I'll click run at the bottom of the panel and my data will be pulled into the sheet!
Now let's create a quick chart to show off this data. Select all the fields you'd like to display in the chart.
Now let's create a quick chart to show off this data. Select all the fields you'd like to display in the chart.
That's it! The chart should display next to your data. Now you can update your query and rerun it to update your chart or add new information.