일괄 업로드
컬렉션을 사용해 정리하기 내 환경설정을 기준으로 콘텐츠를 저장하고 분류하세요.
Google Drive에서 일괄 업로드
function bulkUploadFromGoogleDrive() { // See https://developers.google.com/google-ads/scripts/docs/features/bulk-upload // for the list of supported bulk upload templates. // You can upload a CSV file, or an EXCEL sheet. const file = DriveApp.getFilesByName('BulkCampaignUpload.csv').next(); const upload = AdsApp.bulkUploads().newFileUpload(file); upload.forCampaignManagement(); // Use upload.apply() to make changes without previewing. upload.preview(); }
원격 서버에서 일괄 업로드
function bulkUploadFromRemoteServer(csvFileUrl) { // See https://developers.google.com/google-ads/scripts/docs/features/bulk-upload // for the list of supported bulk upload templates. const blob = UrlFetchApp.fetch(csvFileUrl) .getBlob() .getAs(MimeType.CSV); const upload = AdsApp.bulkUploads().newFileUpload(blob); upload.forCampaignManagement(); // Use upload.apply() to make changes without previewing. upload.preview(); }
Google Sheets에서 일괄 업로드
function bulkUploadFromGoogleSpreadsheet(spreadsheetUrl) { // The format of this spreadsheet should match a valid bulk upload template. // See https://developers.google.com/google-ads/scripts/docs/features/bulk-upload // for the list of supported bulk upload templates. const spreadSheet = SpreadsheetApp.openByUrl(spreadsheetUrl); const sheet = spreadSheet.getActiveSheet(); const upload = AdsApp.bulkUploads().newFileUpload(sheet); upload.forCampaignManagement(); // Use upload.apply() to make changes without previewing. upload.preview(); }
캠페인 만들기/업데이트
function createOrUpdateCampaigns() { // See https://developers.google.com/google-ads/scripts/docs/features/bulk-upload // for the list of supported bulk upload templates and their column names. const columns = [ 'Campaign', 'Budget', 'Bid Strategy type', 'Campaign type' ]; const upload = AdsApp.bulkUploads().newCsvUpload( columns, {moneyInMicros: false}); // Google Ads identify existing campaigns using its name. To create a new // campaign, use a campaign name that doesn't exist in your account. upload.append({ 'Campaign': 'Test Campaign 1', 'Budget': 234, 'Bid Strategy type': 'cpc', 'Campaign type': 'Search Only' }); // Use upload.apply() to make changes without previewing. upload.preview(); }
달리 명시되지 않는 한 이 페이지의 콘텐츠에는 Creative Commons Attribution 4.0 라이선스에 따라 라이선스가 부여되며, 코드 샘플에는 Apache 2.0 라이선스에 따라 라이선스가 부여됩니다. 자세한 내용은 Google Developers 사이트 정책을 참조하세요. 자바는 Oracle 및/또는 Oracle 계열사의 등록 상표입니다.
최종 업데이트: 2025-08-21(UTC)
[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["필요한 정보가 없음","missingTheInformationINeed","thumb-down"],["너무 복잡함/단계 수가 너무 많음","tooComplicatedTooManySteps","thumb-down"],["오래됨","outOfDate","thumb-down"],["번역 문제","translationIssue","thumb-down"],["샘플/코드 문제","samplesCodeIssue","thumb-down"],["기타","otherDown","thumb-down"]],["최종 업데이트: 2025-08-21(UTC)"],[[["\u003cp\u003eThis script provides functionalities to bulk upload data into Google Ads from various sources like Google Drive, remote servers, and Google Sheets.\u003c/p\u003e\n"],["\u003cp\u003eIt utilizes Google Ads Scripts' bulk upload feature to manage and update campaigns, using CSV or spreadsheet files formatted according to specified templates.\u003c/p\u003e\n"],["\u003cp\u003eThe examples demonstrate how to preview changes before applying them, ensuring accuracy in bulk operations.\u003c/p\u003e\n"],["\u003cp\u003eThe script allows creation or updating of existing campaigns by providing the necessary campaign details like name, budget, bid strategy, and type.\u003c/p\u003e\n"],["\u003cp\u003eBefore execution, users should consult the provided link for understanding supported bulk upload templates and their required column names.\u003c/p\u003e\n"]]],[],null,["Bulk upload from Google Drive \n\n```gdscript\nfunction bulkUploadFromGoogleDrive() {\n // See https://developers.google.com/google-ads/scripts/docs/features/bulk-upload\n // for the list of supported bulk upload templates.\n // You can upload a CSV file, or an EXCEL sheet.\n const file = DriveApp.getFilesByName('BulkCampaignUpload.csv').next();\n const upload = AdsApp.bulkUploads().newFileUpload(file);\n upload.forCampaignManagement();\n\n // Use upload.apply() to make changes without previewing.\n upload.preview();\n}\n```\n\nBulk upload from remote server \n\n```gdscript\nfunction bulkUploadFromRemoteServer(csvFileUrl) {\n // See https://developers.google.com/google-ads/scripts/docs/features/bulk-upload\n // for the list of supported bulk upload templates.\n const blob = UrlFetchApp.fetch(csvFileUrl)\n .getBlob()\n .getAs(MimeType.CSV);\n\n const upload = AdsApp.bulkUploads().newFileUpload(blob);\n upload.forCampaignManagement();\n\n // Use upload.apply() to make changes without previewing.\n upload.preview();\n}\n```\n\nBulk upload from Google Sheets \n\n```gdscript\nfunction bulkUploadFromGoogleSpreadsheet(spreadsheetUrl) {\n // The format of this spreadsheet should match a valid bulk upload template.\n // See https://developers.google.com/google-ads/scripts/docs/features/bulk-upload\n // for the list of supported bulk upload templates.\n const spreadSheet = SpreadsheetApp.openByUrl(spreadsheetUrl);\n const sheet = spreadSheet.getActiveSheet();\n\n const upload = AdsApp.bulkUploads().newFileUpload(sheet);\n upload.forCampaignManagement();\n\n // Use upload.apply() to make changes without previewing.\n upload.preview();\n}\n```\n\nCreate/update campaigns \n\n```gdscript\nfunction createOrUpdateCampaigns() {\n // See https://developers.google.com/google-ads/scripts/docs/features/bulk-upload\n // for the list of supported bulk upload templates and their column names.\n const columns = [\n 'Campaign', 'Budget', 'Bid Strategy type', 'Campaign type'\n ];\n\n const upload = AdsApp.bulkUploads().newCsvUpload(\n columns, {moneyInMicros: false});\n\n // Google Ads identify existing campaigns using its name. To create a new\n // campaign, use a campaign name that doesn't exist in your account.\n upload.append({\n 'Campaign': 'Test Campaign 1',\n 'Budget': 234,\n 'Bid Strategy type': 'cpc',\n 'Campaign type': 'Search Only'\n });\n // Use upload.apply() to make changes without previewing.\n upload.preview();\n}\n```"]]