Ads script for price extension through sheets

[Deepak Thirumurugan]

Hi,

I was extensively searching for script that can add price extensions to campaign by reading data from sheets but could not find any. But online I found a script that applies call out extension to ad groups by loading data from sheets. Could anyone please help me on changed script for price extension. Please find below the script for callout extension!
Any help is highly appreciated

// 

1. var SPREADSHEET_URL = "https://docs.google.com/spreadsheets/d/1nweIw1aPmaFswrXH92B-qSwDVwqPivkEkMapXEC_-dA/edit#gid=0"
2.  
3.  
4. function main() {
5.     var callouts = load_data(SPREADSHEET_URL);
6.     Logger.log(callouts)
7.     var callouts_objects = create_callouts(callouts);
8.     var apply_results = apply_callouts(callouts);
9. }
10.  
11. function apply_callouts(callouts) {
12.     var results = new Array();
13.     for (var i = 0; i < callouts.length; i++) {
14.         if (!callouts[i]["Status"]) continue;
15.  
16.         var campaign_filter = callouts[i]["Campaign Contains"].toLowerCase();
17.         var ad_group_filter = callouts[i]["AdGroup Contains"].toLowerCase();
18.  
19.         campaign_filter = campaign_filter == "any" ? false : campaign_filter;
20.         ad_group_filter = ad_group_filter == "any" ? false : campaign_filter;
21.  
22.         var ad_groups_selector = AdsApp.adGroups();
23.  
24.         if (campaign_filter) {
25.             ad_groups_selector.withCondition("CampaignName CONTAINS_IGNORE_CASE '" + campaign_filter + "'");
26.         }
27.         if (ad_group_filter) {
28.             ad_groups_selector.withCondition("Name CONTAINS_IGNORE_CASE '" + ad_group_filter + "'");
29.         }
30.         var adGroupIterator = ad_groups_selector.get();
31.  
32.         while (adGroupIterator.hasNext()) {
33.             ad_group = ad_groups_selector.next();
34.  
35.             var operation = ad_group.addCallout(callouts[i]["Callout"]);
36.  
37.  
38.             result = {
39.                 "AdGroupName": ad_group.getName(),
40.                 "Campaign Contains": campaign_filter,
41.                 "AdGroup Contains": ad_group_filter,
42.                 "Result": ad_group.getResult(),
43.                 "Error": ad_group.getErrors()
44.  
45.             }
46.  
47.             results.push(result);
48.  
49.  
50.  
51.         }
52.     }
53.  
54.     return results;
55.  
56. }
57.  
58.  
59. function create_callouts(callouts) {
60.     var results = new Array();
61.     for (var i = 0; i < callouts.length; i++) {
62.  
63.         var calloutBuilder = AdsApp.extensions().newCalloutBuilder();
64.  
65.         var mobile_pref = callouts[i]["Mobile Preffered"].toLowerCase() == "any" ? true : false;
66.         // Create a callout operation.
67.         var calloutOperation = calloutBuilder
68.             .withText(callouts[i]["Callout"]) // required
69.             .withMobilePreferred(mobile_pref) // optional
70.             .build();
71.  
72.         // Optional: examine the outcome. The call to isSuccessful()
73.         // will block until the operation completes.
74.         if (calloutOperation.isSuccessful()) {
75.             // Get the result.
76.             var callout = calloutOperation.getResult();
77.             results.push({
78.                 "Status": true,
79.                 "Callout": callout,
80.                 "Campaign Contains": callouts[i]["Campaign Contains"],
81.                 "AdGroup Contains": callouts[i]["AdGroup Contains"]
82.             });
83.         } else {
84.             // Handle the errors.
85.             var errors = calloutOperation.getErrors();
86.             results.push({
87.                 "Status": true,
88.                 "Error": errors
89.             });
90.         }
91.  
92.     }
93.  
94.     return results;
95. }
96.  
97. function load_data(url) {
98.  
99.     var reportSheet = SpreadsheetApp.openByUrl(url);
100.     var rows = reportSheet.getDataRange();
101.  
102.     var numRows = rows.getNumRows();
103.     var numCols = rows.getNumColumns();
104.     var values = rows.getValues(); // values[row_index][column_index]
105.  
106.     var row = values[0];
107.     var headerNames = new Array();
108.  
109.     for (var i = 0; i < numCols; i++) {
110.         var columns_name = row[i];
111.         headerNames.push(columns_name);
112.     }
113.  
114.     var data = new Array();
115.     for (var row_index = 1; row_index < numRows; row_index++) {
116.         var row_data = {};
117.         if (!values[row_index]) break;
118.         for (var col_index = 0; col_index < numCols; col_index++) {
119.             var cell_data = values[row_index][col_index];
120.             if (!cell_data) continue;
121.             row_data[headerNames[col_index]] = values[row_index][col_index];
122.         }
123.         if (!size_dict(row_data)) continue;
124.         data.push(row_data);
125.     }
126.  
127.     return data;
128.  
129. }
130.  
131. function size_dict(d) {
132.     c = 0;
133.     for (i in d) ++c;
134.     return c
135. }

Thanks in advance!!

[Google Ads Scripts Forum Advisor]

Hi Deepak,

Thank you for reaching out to us.

With regard to your concern, I'm afraid the script will not work currently as the team is currently working on to update Google Ads Scripts to support asset-based extensions. I humbly ask for your continued patience and be on the lookout for new updates and releases in scripts through our blog in the meantime.

Regards,

Teejay Wennie Google Ads Scripts Team

ref:_00D1U1174p._5004Q2Xket7:ref